Filter static data but not the table scheme

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

Filter static data but not the table scheme

Postby Xaphan » Tue Apr 16, 2013 9: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).
Xaphan
 
Posts: 12
Joined: Fri Apr 20, 2012 11:34 pm

Postby eddie davis » Fri Apr 19, 2013 8: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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby Xaphan » Fri Apr 19, 2013 5: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?
Xaphan
 
Posts: 12
Joined: Fri Apr 20, 2012 11:34 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests