Comments (3)
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.
Related Issues (20)
- Overloading IIS/CRM on-premises - causing slowdown, timeouts for users HOT 2
- Request change attribute types names to match D365 HOT 2
- Get Template Improvement HOT 2
- Export Tables Issue HOT 1
- When selecting file, be more open to other file extensions
- Lookup not configuring field level security (FLS) HOT 1
- Global Choice syncing not tracked HOT 2
- Desperately trying to create field that must reuse an existing Global Choice HOT 8
- n:n relationship HOT 2
- Bug in Template downloaded from XrmToolBox-AttributesFactory v 1.2022.6.15
- Currency Precision HOT 4
- Problem with Choice(s) when using multi-languages Dataverse HOT 15
- Not able to create columns HOT 3
- Swap of "Display name" to "Description" HOT 7
- No control over schema name for generated Relationships HOT 9
- Data type "Autonumber" not supported HOT 2
- Adding functionality for formula type columns HOT 12
- Feature request for column deletion HOT 2
- Feature request - export table information by filtering on columns contained in / excluded from form(s) HOT 4
- Missing table detected but table exists HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from javista.attributesfactory.