Using Template to migrate SQL Tables to Dataverse about javista.attributesfactory HOT 3 CLOSED

Hi @ozdemir-mehmet, I'm not sure to understand why you updated the template. If you want to migrate SQL to dataverse, then just filling the template should have been enough, right?
Migrating the data is another task that has nothing to do with this tool.
Can you be more precise on what are the benefit of your changes?

from javista.attributesfactory.

Say I have a SQL table with 80 fields, some are varchar, int, float, date, datetime, some nullable some not etc..
Using the template I would need to copy-paste 80 field names, then type the Display name (typically add a space), then map the datatypes to corresponding Dataverse datatype, set required drop-down, then tab across to the right section (eg text and put the field lengths in etc.

This can be quite a time-consuming task (but still better than using the UI)... In my version I just dump the schema definition from SQL Server (that the data you see to the right of the template), then my modified spreadsheet parses it, determines Display Name, Schema Name, Datatype, Length, Busines Required etc. The field in the main template are auto-populated based on the SQL schema details.

This isn't about importing data, it's about speeding up Dataverse table creation when you already have the schema defined in a SQL Table (and you're migrating a table across to Dataverse).

Does that make more sense?

from javista.attributesfactory.

Seems to specific to me to be implemented by myself

from javista.attributesfactory.