How can we help you today? How can we help you today?

Exclude tables from comparison

I am using the SQL Compare in conjunction with Data Compare to sync the DB on several tablet pc's with a master server DB. My problem is that I only want to sync certain tables from master server DB with the tablet DB. I know when you use the program you can check and uncheck each table for synchonization, but I am creating an app using the Toolkit and wish to do this programatically, in VB.net. Thanks in advance,
Matt Barnes
Barnestorm, Inc.
mpbarnes27615
0

Comments

3 comments

Sort by
  • Brian Donahue
    Hello Matt,

    Yes, you can choose the tables to synchronize using the Toolkit. If you look at the sample code for SQL Compare, there is a bit that loops through all of the differences and sets their Selected property to True. This is how you select objects to be scripted. You could include a conditional statement (an if) somewhere in this loop to include objects by name or by type.
    Brian Donahue
    0
  • mpbarnes27615
    Thanks for the reply,
    that did it.
    Matt Barnes
    Barnestorm, Inc.
    mpbarnes27615
    0
  • Brian Donahue
    Hi,

    It's probably the 'includedependencies' SQL Option that's scripting dependent objects. You can try taking that option out of the Options enumeration rather than using Options.Default, but that may cause the script to fail, depending.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.