Export/Import Database of SQL SERVER using MS SQL Management Studio

Export/Import Database of SQL SERVER using MS SQL Management Studio

book

Article ID: KB0078109

calendar_today

Updated On:

Products Versions
TIBCO MDM ALL

Description

We may need to sync the Data(Copy from one to another) of two environments in MDM with SQL SERVER database.For this we need complete data along with enterprise directory to function the MDM properly.

Need to follow below steps the complete this activity.


 

Issue/Introduction

Exporting the complete database from one environment and importing the same on another environment using MS SQL Management Studio

Environment

MDM with MS SQL SERVER database

Resolution

 1) Open MS SQL Server Studio right click on the respective Database(MDM PROD database) from the Databases,and choose tasks option and click on "Extract Data-tier Application". User-added image User-added image 2) once the export completes and it will store the data under specified location and mentioned file name as per above screenshots. 3) Need to import the same data into your MDM database by right click on Databases and choosing Import Data-tier Application. User-added image 4) Once the database import is done,We need to copy the respective common/enterprise directory of existing environment to other environment to access the MDM Application. Note: You can check following KB on how to restore the it https://supportapps.tibco.com/ka/article/554/000022554.htm

Additional Information

https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/start-the-sql-server-import-and-export-wizard?view=sql-server-2017, https://www.youtube.com/watch?v=QdKOqlD_3jw ,
Powered by Wolken Software