Post reply

synchronize structure of two databases

  • February 22, 2011 at 3:59 am

    #235435

    Hi all!!!

    I want to know if someone know a tool to mantein two databases equal.

    The idea is:

    I have a central database, we use that db for our system, but our system is used in another company. Once a month we send them a new version of our system, right now we are not using sql server as the main db, so the problem is that now we start using sql server.

    Now we have an installer that makes all changes needed in the db (not sql server, dbf files). But when we start using sql server we have a problem, we have to do all changes manually

    hope you understand my problem.

    I want to kwow if there is a tool that compares two dbs and makes all changes I need.

    I research some,

    SQL Delta[/url]

    Red Gate[/url]

    SQL Examiner[/url]

    Thanks a lot!!!

  • February 22, 2011 at 4:05 am

    #1289759

    RedGate compare is a good product for this;

    If you are needing to make data changes as well then you can use RedGate Data compare as well,.

  • February 22, 2011 at 4:10 am

    #1289760

    Thanks for reply.

    I don't need data compare. I'll try this tool.

    Do you know if I can integrate with an installer o something like this?

  • February 22, 2011 at 4:12 am

    #1289761

    gheinze (2/22/2011)

    Thanks for reply.

    I don't need data compare. I'll try this tool.

    Do you know if I can integrate with an installer o something like this?

    not sure, you can run it from the command line if that helps

  • February 22, 2011 at 4:16 am

    #1289762

    steveb. (2/22/2011)

    gheinze (2/22/2011)

    Thanks for reply.

    I don't need data compare. I'll try this tool.

    Do you know if I can integrate with an installer o something like this?

    not sure, you can run it from the command line if that helps

    Thansk for reply again

    Yes It will help if I can do it unattended.

    Ask in case someone knows a free tool to do this?

    thanks!!

  • February 22, 2011 at 5:08 am

    #1289777

    cant you logship or mirror the databases?

  • February 22, 2011 at 5:19 am

    #1289785

    From the sounds of the OP, I think it would be worth looking into Visual Studio for deploying databases/database changes. Of course Visual Studio is not free...

    ------------------------------------------------------------------------
    Bite-sized fiction (with added teeth) [/url]

  • February 22, 2011 at 8:08 am

    #1289872

    Thanks for reply

    logship or mirror the databases

    I have to read about it, because I dont understant how it works and don't know if it will help with my problem. Sorry about it.

    Visual Studio for deploying databases/database changes.

    This tool will make changes to the structure on a production database without loosing data or its only for developers.

    Thanks!!!! 😀

  • February 22, 2011 at 8:26 am

    #1289882

    mirroring

    logshipping

    and replication are technics to keep the data in sync of databases

    all with their own cons and pros

    mirroring is even more for the high availibility point of view and not working for you as the mirrored database cannot be accessed

    logshipping is a possibility, every transaction will be backupped and copied to youre 2nd database location and will be restored there as frequent as you want. only disadvantage while the log is restoring the database is cannot be accessed.

    Replication also a possibility and the subscriber (youre 2nd database) can always be accessed (disadvantage if objects changing you need to rebuild you replication)

    as you do it now once every x months, i think snapshot replication every night will be already a huge improvement. easy to setup.

    But all this requires that sql server a can reach sql server b.

  • February 22, 2011 at 8:39 am

    #1289891

    There is an SDK for SQL Compare from Red Gate. The other tools might have one as well

    http://www.red-gate.com/products/sql-development/sql-comparison-sdk/

    Disclosure: I work for Red Gate.

    In terms of LS/Repl/Mirror, the OP doesn't look to move data, so these don't apply.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • February 22, 2011 at 8:49 am

    #1289898

    Thanks Marco, but I don't need data sync I only need Structure sync, because we distribute our app to another company.

    Thanks for reply.

    Steve, thanks to you too.

    We are going to try this tool and see if we can solve our issue.

    Red Gate SQL Compare[/url]

    The SDK it a good option too, I will see it too.

Viewing 11 posts - 1 through 10 (of 10 total)

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