Comparing 2 script folders with identical files

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Comparing 2 script folders with identical files

Postby apeddle2 » Thu Oct 17, 2013 5:53 pm

When I run the compare of 2 folders with the same files the compare wants to update each folder with the others contents. The results should come back as having identical content. Any ideas? I'm using SQL Compare v8 Thank you!
apeddle2
 
Posts: 3
Joined: Thu Oct 17, 2013 5:25 pm

Solved my own problem

Postby apeddle2 » Thu Oct 17, 2013 6:25 pm

I createed the scripts folders via the RedGate menu.
Thanks,
Andy
apeddle2
 
Posts: 3
Joined: Thu Oct 17, 2013 5:25 pm

Postby Brian Donahue » Mon Oct 21, 2013 4:31 pm

Thanks for following up!
Initializing scripts folders using SQL Compare creates the RedGateDatabaseInfo.xml file, which can be important if there are differences in collation. You can specify a default collation in that file and if one set of folders has it and one does not you may see differences triggered in columns because of a differing default collation.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby apeddle2 » Mon Oct 21, 2013 4:33 pm

Excellent Brian. Thank you. I realized I moved the xml file out so the compare thought each file was different. Creating them via the menu re-established the xml files for me. This can be closed.
Thanks,

-Andy
apeddle2
 
Posts: 3
Joined: Thu Oct 17, 2013 5:25 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 2 guests

cron