Migrating repository and database

  • Thread starter Thread starter Darren Nelson
  • Start date Start date
D

Darren Nelson

anyone have any idea how to move a repository and mssql database from
one dev machine to another?
 
The short of it is:
1. detach the MantisSQL DB, copy it to the new machine
2. attach the mantissql db to the new instance of sql svc at the new
machine. (you can ignore the LDF, you only need the MDF here, ignore
the warning about the missing ldf when attaching)
3. xcopy the reps over to the new machine (recreate the share name at
the new location)
4. in Database Manager, change the "connect to" db name to the new
machine name
5. in database manager under the repository tab, change the location
path UNC from the old machine to the new machine name (dince you
xcopy'd the reps, you can uncheck the box for "move rep files to new
location")
6. IMPORTANT ; people tend to skip this one and it will burn you later
if you forget - under the rep tab you also need to click the
"repository roots" button. DELETE the old UNC entry, enter the new UNC
entry for all future reps that are created on this machine.

it's about a 15 minute process, mostly due to having to copy over the
MDF and reps
 
Taken from SP2 documentation:
Backing Up the Component Database

1. Stop your database server services.
If you use MSDE, from the Start menu, choose Run, and then type
Services.msc. Choose MSSQLSERVER and then choose Stop.
- or -
If you use Microsoft SQL Server, from the Start menu, choose All
Programs, choose Microsoft SQL Server, choose Service Manager, and then
choose Stop.
2. Open Windows Explorer, and navigate to the $:\Windows Embedded Data
folder.
3. From the Windows Embedded Data folder, copy both MantisSQLDB_log.LDF and
MantisSQLDB_Data.mdf to another folder on this computer, a network
location, or other storage media, as backup copies.
4. Access your database service as you did in step 1, and then select Start.

Backing Up the Repository

When you back up the component database, you should also back up the
repositories that are used with that version of the component database. You
can back up the repository folders to a network location, another folder on
your computer, or to large capacity removable media. The repositories can be
quite large, so if you if you are storing them on removable media, the
backup may span multiple discs.

1. Locate your repository folders. For example, D:\Windows Embedded
Data\Repositories.
2. Open a backup utility. For example, in Windows XP Professional, from the
Start menu, choose All Programs, choose Accessories, choose System
Tools, and then choose Backup.
You can also use other third-party backup utilities. These are often
included with backup hardware or removable storage devices.
3. Follow the instructions provided on screen or in your backup utility's
documentation to back up the folders in the Repositories folder.


Restoring the Repository from Backup

1. Open your backup utility and follow the instructions on your screen or in
your backup utility's documentation to restore the repository folders. Be
sure to select the previous backup location, not the backup that you
just created for your current repository.
- or -
If your backup utility does not include a restore feature, locate your
previous backup location, and copy those folders to your repository folder.
For example, copy them to D:\Windows Embedded Data\Repositories.

Restoring the Component Database from Backup

1. From your previous backup location, copy both the MantisSQLDB_log.LDF and
MantisSQLDB_Data.mdf files to the Windows Embedded Data folder. For
example, copy them to D:\Windows Embedded Data.
2. Start your database server services.
If you use MSDE, from the Start menu, choose Run, and then type
Services.msc. Choose MSSQLSERVER and then choose Start.
- or -
If you use Microsoft SQL Server, from the Start menu, choose All
Programs, choose Microsoft SQL Server, choose Service Manager, and then
choose Start.

Please let me know if you have any problems.
Brett
 
Back
Top