Post reply

Data Migration between sql server 2005

  • February 8, 2010 at 11:37 am

    #74213

    Hi all Experts,

    I need some advices and recommendations on the following

    A) We have a requirement that to Migrate databases between two

    2005 sql servers.Which are at two different locations

    B) The new platform will still be SQL Server 2005, but the entire data structure will change.

    I am new to DBA so also with Data Migration

    So All pls do help on this

    Thanks in Advance

    MJ

  • February 8, 2010 at 11:49 am

    #1115702

    run SQL upgrade advisor (http://www.microsoft.com/downloads/details.aspx?FamilyID=1470e86b-7e05-4322-a677-95ab44f12d75&displaylang=en)

    on a test server (restore backup from production) and go with the recommendations

    -------------------------------------------------
    -Amit
    Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply