Migrating to a new workstation

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

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

Migrating to a new workstation

Postby fcheung » Fri Aug 30, 2013 9:51 pm

I am migrating from a Win7 computer to a Win8 computer.

How do i migrate all the database i've linked from the old computer?

I can relink everything but i've about 30 databases, just trying to avoid the hassle.

thanks.
fcheung
 
Posts: 3
Joined: Fri Aug 30, 2013 9:45 pm
Location: United States

Postby andy.campbell.smith » Mon Sep 02, 2013 4:33 pm

If you copy the file %localappdata%\\Red Gate\\SQL Source Control 3\\LinkedDatabases.xml to the same location on your new PC, that ought to copy across all the linked database information. This isn't strictly supported behaviour, so let me know if anything goes squiffy, but it ought to work!
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby fcheung » Tue Sep 03, 2013 10:02 pm

i tried that already but when i clicked on a linked DB in management studio, it generates an error

C:\\Users\\xxxx\\AppData\\Local\\Red Gate\\SQL Source Control 3\\WorkingBases\\5xgl0qlm.3t2.

I also tried to copy everything under AppData\\Local\\Red Gate\\SQL Source Control 3 to the new server, got the same error

Any idea?
fcheung
 
Posts: 3
Joined: Fri Aug 30, 2013 9:45 pm
Location: United States

Postby andy.campbell.smith » Wed Sep 04, 2013 11:21 am

Which source control system are you using?
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby fcheung » Thu Sep 05, 2013 5:50 pm

I am using TFS
fcheung
 
Posts: 3
Joined: Fri Aug 30, 2013 9:45 pm
Location: United States

copying LinkedDatabases.xml would be really useful

Postby fpdave100 » Mon Jul 28, 2014 11:27 am

or an automated way of setting up links, as we have ~100 dbs (over 9 environments - TFS branches, test releases, etc), and having each developer do this is wasteful.

I tried to copy the LinkedDatabases.xml, but it gave an error that
"there's no workspace mapping for ..."
fpdave100
 
Posts: 2
Joined: Fri Feb 15, 2013 5:24 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest