Red Gate forums :: View topic - Moving from shared to dedicated development
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Moving from shared to dedicated development

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message

Joined: 01 Oct 2012
Posts: 2

PostPosted: Thu Oct 18, 2012 5:45 pm    Post subject: Moving from shared to dedicated development Reply with quote

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

Back to top
View user's profile Send private message
eddie davis

Joined: 14 Jun 2006
Posts: 941
Location: Red Gate Software

PostPosted: Mon Oct 22, 2012 11:15 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group