Activity overview
Latest activity by PizzaSlice
To get around the issue where SQL Compare doesn't compare two tables that are the same on two databases (like local and production), but are different according to SQL Compare because the owners are different (i.e. [dbo].[tblCompany] and [abc].[tblCompany]) I do the following:
Script the production database using SQL Enterprise Manager to a file on your local machine. Open the scripted file, find/replace all instances of [abc] and change it to [dbo]. Then, on the development database server, create a new database and run the script you just made. Now, you have two databases on your development machine:
dbApplication
dbApplication_live
both have the owner [dbo] on all the objects. Run SQL Compare between the two databases and you'll get what you're looking for.
I hope this helps ANYBODY out there. Boy, lot's of people are going to be upgrading when they come out with a new release! [image] / comments
To get around the issue where SQL Compare doesn't compare two tables that are the same on two databases (like local and production), but are different according to SQL Compare because the owners ar...