deploying data from subversion

tbuxton

We have a number of datasource branches in subversion. When we use SQL Data Compare Pro 10.2.3.5 to compare sourcecontrol db (and migration script) with destination db the software is not picking up any linked static data from svn.

The data (table_data.sql) files generated using the linked static data feature of SQL Source Control for a linked subversion datasource do exist in the branch. I've check data compare setting and search the forum but haven't turned up anything.

Is it possible to deploy linked static data from subversion using SQL data compare? HELP! thanks

Brian Donahue

I believe the only way to deploy with static data is to use SQL Compare (rather than SQL Data Compare) command-line.

An option exists in the later 10.x builds of SQL Compare under the /include argument:

sqlcompare.exe /include:StaticData