replicating DB

Discussion in 'Databases' started by fractal, Jul 11, 2011.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. fractal

    fractal

    I would like two have a copy of the database and website in Discount server in Europe to comply with disaster recivery policies of a client, copying the website is easy, only need to be copied gaian when a change is made, but how can I keep an updated copy of the US Database in the SQL Database in the Europe Server?

    The copy can be one day old.

    Thanks!
     
    fractal, Jul 11, 2011
    #1
  2. wisemx

    wisemx

    I think you will need someone to have a local version of SQL Server and create a SSIS package that will pump the data, filter it, and pump it back out for the replication.

    What that would do is copy what you want when you want from any location you want.
    It could also be automated for whoever is doing it.
     
    wisemx, Jul 11, 2011
    #2
  3. Michael Ossou

    Michael Ossou

    Just to be clear.

    Do you have a SQL account here and in EU? Is there anything in your EU account? Meaning can you use it solely for backup storage?
     
    Michael Ossou, Jul 11, 2011
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page