Unsolved
This post is more than 5 years old
5 Posts
0
298
February 11th, 2009 07:00
SQL source Data folder different from target Data folder
I want to use Replistor to migrate a SQL2005 instance to a new server. The source instance was originally SQL 2000, then upgraded to SQL2005. The path to the data is ...\MSSQL\Data\... The new server has a fresh install of SQL2005, which placed the data in ...\MSSQL.1\MSSQL\Data...
The problem is that when specifying the target folder, there is no option to modify the path to the target, only option is Same As Source or Default Target Directory.
Is there a work-around?
The problem is that when specifying the target folder, there is no option to modify the path to the target, only option is Same As Source or Default Target Directory.
Is there a work-around?
No Events found!
dramjass
151 Posts
0
February 11th, 2009 08:00
If you are savvy enough, you can modify the replicated master.mdf to reflect the new DB/Log paths.
The reason you only have the 2 options 9 Same As Source or Default Target Directory) is because the Spec's were created as a Group Spec. When this is done, the paths must be identical or the Default Target Directory must be used. This behavior is expected.
To get around this, simply create another Spec for the DB/Log you need to migrate (diable the original) and Sync it.
Let me know if you have any questions.
Duncan
tribicic
157 Posts
0
February 11th, 2009 08:00