Copy database

ageorgiouageorgiou Posts: 2
edited October 29, 2014 12:51PM in SQL Compare 11
I'm new here.
I wanted to see if there is a tool to keep database B uptodate as yesterday from database A with out dropping database B, backup database A to a file and create a new database B from that backup copy.

Doe the SQL compare can it keep two database uptoday where the B database is as of yesterday since is my copy database from the live version? maybe run this routine once a day?

the way I'm doing this today where I back up to a file and restoring that to a new database from that file is taking a lot of resources.

Thank you,
Andrew

Comments

  • Hi Andrew,

    Thanks for your post.

    SQL Compare can compare the schema of two databases and generate a script that will synchronize the target database to the source. For example, if you add a table to the source database, then run SQL Compare, it will generate a script with a "CREATE TABLE" statement you can run on the target.

    It sounds like SQL Data Compare might be more what you're looking for -- this will look at the data within tables or views and compare that. So if your source table gets 30 rows added to it before you run SQL Data Compare, it will generate a script with 30 "INSERT" statements to run on the target. You can also do all of this from the command line, so you can schedule it for whenever you need.

    That being said, it's not guaranteed to be faster than doing a backup and restore, because it can get decently expensive to look through every row in each of the tables you're comparing. I'd suggest doing some testing with our two week free trial.

    Regards,
    Evan
    Evan Moss
    Product Support
    (866) 627-8107
Sign In or Register to comment.