Options

Filter static data but not the table scheme

XaphanXaphan Posts: 18
edited April 19, 2013 12:14PM in SQL Compare Previous Versions
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).
· Share on Twitter

Comments

  • Options
    Eddie DEddie D Posts: 1,780 Rose Gold 5
    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
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
  • Options
    XaphanXaphan Posts: 18
    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?
    · Share on Twitter
Sign In or Register to comment.