migration | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


i actually finished tables and stored procedures in dev environment,i want to do same work in TEST and UAT environmenats how could i do i know it can be done by migration but i donot know what steps i have to follow, please help IN STEP WISE SRJ2005
Do you want to copy structures with data?
Take a back up and restore it in other envirionments Madhivanan Failing to plan is Planning to fail
Hi,<br />what exactly you wants to do ?! do want to migrate from sql 7 to sql 2000 ? <br />please brief some more to get a good answer<br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
KBAs and article for your reference:
http://vyaskn.tripod.com/moving_sql_server.htm If you need only stored procedures and views then you can script them and use the same on test & UAT environments, for data use DTS to accomplish the task. For many table backup/restore is best method. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Prepare create/alter table scripts and create proc scripts for realease in another environmnent. Have a subset of production dbs on qa db servers. Test release scripts with begin tran in front. Than run queries that will check if changes are in place and working properly from the same window in query analyzer. Finally, commit or rollback transaction based on tests success.