/include:staticdata including all tables

ddorvalddorval Posts: 12
edited November 15, 2012 6:19AM in SQL Compare Previous Versions
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:?

Comments

Sign In or Register to comment.