I'm trying to use dbForge Schema Compare and Data Compare to export data from a database into a new database - but after I complete running it it always shows a few things as being different - even though no one is using the database - why?
For example, it will show things like ANSI_NULLS as being ON in the original database but OFF in the destination database.
Dave
Why is Comparison Always Different?
-
alexa
Re: Why is Comparison Always Different?
Could you please provide us some more information by answering the questions below:
1. Had the databases had different settings before they were synchronized?
2. Have the settings been synchronized?
3. What options were selected on the 'Options' pages of the New Schema Comparison and Schema Synchronization wizards?
4. Please list the objects with differences and describe the differences.
Please also provide us any other information on this issue that may help us to reproduce it.
1. Had the databases had different settings before they were synchronized?
2. Have the settings been synchronized?
3. What options were selected on the 'Options' pages of the New Schema Comparison and Schema Synchronization wizards?
4. Please list the objects with differences and describe the differences.
Please also provide us any other information on this issue that may help us to reproduce it.