deploying data from subversion

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

deploying data from subversion

Postby tbuxton » Wed Nov 14, 2012 12:13 am

We have a number of datasource branches in subversion. When we use SQL Data Compare Pro 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
Posts: 1
Joined: Wed Nov 14, 2012 12:05 am

Postby Brian Donahue » Wed Nov 14, 2012 12:31 pm

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:
Code: Select all
sqlcompare.exe /include:StaticData
Brian Donahue
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests