Post reply

Copy data from database to new database

  • September 18, 2014 at 8:41 am

    #397366

    Hi,

    as you can read here I must change the collation of my database. What would be the best and fastest way to do this. I got only the night. And how could I check aftwerwards if the two databases are totally in sync?

    Greetz
    Query Shepherd

  • September 18, 2014 at 9:09 am

    #1746445

    Your best option is BPC the data out using native format and then BPC in.

    You will have to disable FK contraints if you have any.

    I suggest that you decide a maintenance window and make the database unavailable rather than working on a copy: syncing the two copies will require some effort.

    -- Gianluca Sartori

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

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