How to unlink data on new database

GilbertLiddell · April 26, 2011 4:31AM

Hi,

I have a database under source control in TFS. I use this as my main database for development, all changes are made to this database and checked in. I also have checked in my "base" data from this database.

I now want a second database, this will be the database that I run unit tests against. I want to link this database to the same database under source control above but when I check-out, I only want to get the schema, not the data.

Currently, when I link the test database and de-select the data for that table, it automatically de-selects the table as well.

How can I choose to checkout a schema from the database under source control without taking the data? Is there maybe a command line tool or have I missed something :-(

Thanks in advance for your help.
Gilbert.

peter.peart · April 29, 2011 6:37AM

Hi there,

Thanks for your post. At the present time, this isn't possible, however I've raised it as an enhancement in our systems under an internal tracking number of SOC-2489. This will definitely be considered for future releases of the tool so watch this space!

Pete

David Atkinson · April 29, 2011 3:49PM

The SQL Compare Pro command line can be used to build up a database from a source controlled scripts folder for the purposes of running automated unit tests. SQL Compare will pull the schema component and SQL Data Compare will pull the data component, allowing you to treat them separately. There is a paper that describes how to set up continuous integration:

http://downloads.red-gate.com/HelpPDF/C ... LTools.pdf

Please use this approach to build a test database and if for whatever reason it doesn't work for you, let us know!

Kind regards,

David Atkinson
Product Manager
Red Gate Software

How to unlink data on new database

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk