Moving a Model to a Different Database
There are two ways of moving a model to a different database:
• By exporting the model to a directory, and then importing that model to a different to a different database.
• By cloning the model to a different database.
|
|
When you clone a model:
• The ID of the new model will be different to that of the model that was cloned.
• The source and target databases must be accessible from Model Explorer on one computer.
|
To copy a model through an export and import operation:
To Export the model:
1. On a computer from which Model Explorer can access the model to be exported, start Model Explorer.
2. Locate the version of the model you want to move.
3. Right-click the model, and then click Export.
4. Select the destination folder.
5. In the File Name box, type the name of the export file.
6. Click Save.
7. From the confirmation dialog, click Yes.
To Import the model:
1. On a computer from which Model Explorer can access the target database, start Model Explorer.
2. Locate the Database to which you want to move the model.
3. Right-click the database, and then click Import Model.
4. Select the file you exported, and then click Open.
5. From the confirmation dialog, click Yes.
The model is available in the target database.
To copy a Model through a Clone Operation:
1. On a computer from which Model Explorer can access the source and target databases, start Model Explorer.
2. Locate the version of the model you want to move.
3. Right-click the model, point to Clone, point to Clone to Another Database, and then click Retain Access Permissions.
If you want to move the model to a database on a different server:
1. In the Instance box, type the name of the SQL Server instance in the following format: <machine-name>@<instance-name>
2. Click Connect.
3. In the Database list, select the target Database, and then click OK.
4. From the confirmation dialog, click Yes.
5. When the clone is complete, right-click the target database, and then click Refresh.
6. Model Explorer clones the model and prefixes the name of the new model with 'Clone of'.
7. If you want to remove 'Clone of' text from the name of the model:
a. Right-click the model, and then click Rename.
b. Delete 'Clone of' text from the name of the model.
c. Press the Enter key.
The model is available in the target database.
