TD database transplantation Summary

Because the TD on the rdsrv server may be infected by viruses on the PC, it cannot be used now. I installed sqlserver and TD on the local machine to import the data on the server to the local machine.

 

I. Data to be backed up

1. Back up the domsinfo folder in the/program files/common files/Mercury Interactive folder.

2. Back up the td_dir folder

3. Ensure that the database on the rdsrv server is not damaged;

2. Data Migration

1. Port the Access database to the sqlserver Database

A: copy the domsinfo folder to the corresponding directory to replace the newly created domsinfo folder;

B: copy the td_dir folder to the corresponding directory to replace the newly created td_dir folder;

C: Create the project to be transplanted in TD (because the td_dir folder is copied, delete the project to be transplanted first), open the Enterprise Manager of sqlserver, at this point, we can see that the database of the project created in TD already exists; Delete the database and recreate the database with the same name;

D: Right-click the database you just created to execute the import data task, select Microsoft Access for the data source, and select the ACCESS database file to be transplanted for the database (*. (mdb Format) and press next to go to the next step. Select sqlserver as the target source, select local as the server, and select the database you just created. Then, follow the prompts;

E: After the import is successful, change the attributes of the TD user to public and db_owner;

 

Note: After opening TD, you can see the project and content, but one thing is that some content cannot be changed.

Solution: re-create a project in TD, select copy the project that has just been imported successfully when creating the project, and then delete the original project, at this time, any changes to the newly created Project can be made and the imported data content can be included.

 

2. Port the sqlserver database to the sqlserver Database

A: copy the domsinfo folder to the corresponding directory to replace the newly created domsinfo folder;

B: copy the td_dir folder to the corresponding directory to replace the newly created td_dir folder;

C: Create the project to be transplanted in TD (because the td_dir folder is copied, delete the project to be transplanted first), open the Enterprise Manager of sqlserver, at this point, we can see that the database of the project created in TD already exists; Delete the database and recreate the database with the same name;

D: Right-click the database you just created to execute the Data Import Task, select sqlserver as the data source, select rdsrv as the server, select the database of the project you want to transplant for the database, and press next to go to the next step, select sqlserver as the target source, select local as the server, select the database you just created, and select physical directory shown in TD as the import path (currently the local machine is C: \ tools \ TD \ Program \ Project name), then follow the prompts to operate;

E: After the import is successful, change the attributes of the TD user to public and db_owner;

After the import is successful, you can make any changes to the project.

If you do not delete the project name to be transplanted from TD, it is also feasible to change the project path in the projects table in DOMs. mdb, but you have not tried it yet.