Filter static data but not the table scheme

Forum for users of SQL Compare schema synchronization utility

Filter static data but not the table scheme

Postby Xaphan » Tue Apr 16, 2013 8:38 pm

Is there a way I can have SQL compare filter out certain tables for static data, but still compare the table scheme? For example, let's say my source control has tables A, B, and C and they all have static data. I want to compare those tables against tables A, B, and C on my test server. I want the scheme of all three tables to be compared, but I only want the static data of table B to be compared.

How can this be done if it is possible to do? Also, I'm using SQL Compare using the command line (not sure if that makes a difference).
Posts: 12
Joined: Fri Apr 20, 2012 10:34 pm

Postby eddie davis » Fri Apr 19, 2013 7:33 am

Thank you for your forum post.

SQL Compare does not compare data, it will only compare the structure or schema of the database objects. In the scenario you have described where you wish to only compare the static data held in table B between two data sources, I recommend that you evaluate SQL Data Compare.

Further information regarding SQL Data compare can be found HERE.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1148
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Postby Xaphan » Fri Apr 19, 2013 4:14 pm

SQL Compare will compare data if it is static data, which is data that can be stored in source control. I have done this before by using the /Include:StaticData argument in the SQL Compare command line and I have confirmed that this does work. The question that I have is how can I compare tables without the static data only for certain tables?
Posts: 12
Joined: Fri Apr 20, 2012 10:34 pm

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests