Post reply

Data migration

  • March 24, 2012 at 8:15 pm

    #258237

    Is Data migration mean, transfering of database from one server to next (or same server)?

    Are these following are only Data migration methods:

    Method 1: Backup and restore the user databases

    Method 2: Use the "sp_detach_db" and "sp_attach_db" stored procedures (or right click on db in SSMS>task>detach/attach)

    Method 3: Use the Import and Export Data Wizard to copy objects and data between SQL Server databases.

  • March 25, 2012 at 11:49 am

    #1464016

    somebody know the answer

  • March 25, 2012 at 1:37 pm

    #1464037

    The examples you mentioned usually refer to data transfer or database recovery.

    Data migration usually involves two different systems (e.g. two different SQL server versions or to migrate from Oracle to SQL Server).

    A few more methods to transfer data would be

    SSIS, bcp, Bulk Copy, Openrowset, Linked Server, ...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • March 25, 2012 at 2:09 pm

    #1464040

    Thanks Lutz, its really help me to google it.

Viewing 4 posts - 1 through 3 (of 3 total)

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