This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

migrating from test to cert

Question
0

Sign in to vote

what need to be done when we move TABLE from test environment to cert environment. what procedure to be followed ,

during this process of migrating from TEST to CERT.

CAN ANYONE PLEASE PROVIDE ME WITH DETAILED STEPS TO DO THIS MIGRATION?

THANKS IN ADVANCE.

Tuesday, October 1, 2013 5:09 AM

Answers

1

Sign in to vote
Hello Venkat,

I dont know what is Cert environment but below processes will work

1. Take script of your database (RK on DB..task..script database to ..new query window)

2. Run this query on Cert

3. You can Import export wizard (not present in SQL server 2005 express) to migrate data from dev to cert.

http://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/

http://www.mssqltips.com/sqlservertutorial/202/simple-way-to-export-data-from-sql-server/

4. You can creates SSIS package to move data

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers
- Proposed as answer by vr.babu Tuesday, October 1, 2013 5:27 AM
- Marked as answer by Candy_Zhou Friday, October 11, 2013 9:14 AM
Tuesday, October 1, 2013 5:22 AM