Moving from shared to dedicated development

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moving from shared to dedicated development

Postby SteveS » Thu Oct 18, 2012 4:45 pm

We're trying to move from a shared development setup to dedicated, with the help of Virtual Restore

Currently our db is linked to TFS.
I've restored a backup of the db using virtual restore to the same server.

I'm getting an error when I try and link the restored db to TFS.
I'm trying to link it to the existing path used for the shared db

"An unexpected null value has been found while running postprocessing operations on the script database. Please ensure the script database is consistent. If the problem persists, please contact our support."

Is it possible to do this? Or do I need to create a new repository in TFS?
I don't really want to do this, as it would mean losing the source history

Posts: 2
Joined: Mon Oct 01, 2012 9:58 am

Postby eddie davis » Mon Oct 22, 2012 10:15 am

Thank you for your post into the forum.

I am not sure where SQL Virtual Restore fits into your process. There should be no need to create a TFS repository.

To move from a shared to dedicated development, you need to follow the basic steps below:
    1. Unlink the current shared database from SQL Source Control.
    2. Relink the database to SQL Source Control using the dedicated model.
    3. Create new blank database, for each remaining member of the development team using the dedicated model.
    4. Link each database to the same TFS repository.
    5. Use the 'Get Latest' mechanism to populate the database, repeat for each new database.

I suspect instead of creating a new blank databases in Step 3, you have created Virtual databases using SQL Virtual Restore. There should be no problems performing this action.

A support call has been created for you the call reference is F0065887. If you could send an e-mail to with the call reference number in the subject field with answers to the following questions:

Is the path to TFS repository correct?
Have there been any other folders added to the repository that SQL Source Control, like a sub folder of the database?
Can you please locate the SQL Source Control log file at the time this error occurred for us to look at, it may reveal the cuase of your error? By default the logs files are located in this path:
C:\\Users\\<user_name>\\AppData\\Local\\Red Gate\\Logs\\SQL Source Control 3

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1146
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests