When you have an existing data compare and you change the target, it doesn't work
Take two identical databases on different SQL Server instances (or on prem vs Azure). Ensure they are identical by doing a schema compare. Take a data generation file that is configured and works for one database. Take that file and change the target to the new database. The pre-existing configuration does not get applied to the new database.
The workaround is to create a copy of the existing data generation file, open the new configuration .dgen file in a text editor and change the ConnectionString line in the xml to match the new database's properties. In order to get the new databases connection properties, you have to create a brand new database generation file for the new database and take it from that.
...Kris
-
AdminDevart (_, Devart) commented
Hi KW,
Thanks for your comment!
Please, use https://www.devart.com/support/ to create a ticket and provide us with additional information:
- which version of dbForge Studio for SQL Server do you use?
- share the dgen file
- provide us with steps to reproduce and screenshotsBest,
Devart Support Team