SQL Server Performance

migration

Discussion in 'General DBA Questions' started by reethu, Oct 25, 2005.

  1. reethu New Member

    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
  2. Madhivanan Moderator

    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
  3. ghemant Moderator

    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 />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri Goswami<br />
  4. satya Moderator

    KBAs and article for your reference:
    http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
    http://support.microsoft.com/?id=314546
    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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. mmarovic Active Member

    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.

Share This Page