(877)-718-2617


How to migrate TargetProcess from MSSQL 2000 to MSSQL 2005

Detach your TargetProcess database in MS SQL 2000

1. Open SQL Server Enterprise Manager
2. Right Click on your TargetProcess -> [All Tasks] -> [Detach Database…]



3. Confirm detaching


Attach the database in MS SQL Server 2005

1. Open MS SQL Management Studio
2. Right click on Databases
3. Select [Attach…]



4. Click [Add…]



5. Select the TargetProcess mdf file (usually it is located in Data folder of MS SQL Server 2000 installation directory)



6. You should see something like this.



7. Click [OK] button