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.