/include:staticdata including all tables

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

/include:staticdata including all tables

Postby ddorval » Mon Nov 12, 2012 8:12 pm

I added the /include:staticdata because I want to include the static/linked tables data in my deployment scripts. This switch seems to include ALL tables not just static/linked tables.

I'm comparing a scripts folder with a database. There are 2 tables marked as static/linked in Sql Source Control for a total of about 15 rows. It seemed strange that it was taking so long to "Creating SQL for static data" until I realized it was querying EVERY table in the database. It also generated a script file OVER 3GB.

Is it possible to limit this to only tables marked as static/linked in Sql Source Control..or only to tables in /Data folder in /scripts1:?
ddorval
 
Posts: 8
Joined: Thu Nov 08, 2012 9:13 pm

Postby ddorval » Mon Nov 12, 2012 8:20 pm

Also when comparing 2 scripts folders I get
Error: Object reference not set to an instance of an object.
ddorval
 
Posts: 8
Joined: Thu Nov 08, 2012 9:13 pm

Postby Brian Donahue » Thu Nov 15, 2012 12:19 pm

I'm sorry you have encountered this issue. I will be responding to you via email with the information relevant to troubleshooting this problem.

Thanks!
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests