Re: Sync Schema for Two Databases.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for your comments. Seems like SQL Compare is the way to go.



"Aaron Bertrand [SQL Server MVP]" wrote:

For me, this tool paid for itself in the first couple of days. And I
continue to use it almost daily.

You can also look at Diff from www.apexsql.com ... It is $399 but like
red-gate they have bundles that lower the price per product.

Of course you can do this kind of thing yourself, for free (or almost
free)... You can script the objects in the two databases yourself (with the
features available in Management Studio), compile the results into a single
file, and then perform a diff using windiff or other tools (e.g. That come
with Visual Studio, if you have that). If you have a source control tool,
you can check in one version, then check it out and check in the other
version (giving it the same name), and then you can diff the versions.

But never underestimate the cost of your time, not only when you do it
right, but especially the cost of fixing things if you do it wrong. For
example, unless you are very careful, the script from SSMS will not produce
things in dependency order (and sometimes this can be very difficult to
figure out manually as well). There is also no easy or free way to build a
script that will generate all of the ALTER, CREATE and DROP statements to
make one database look like the other.

A





On 10/16/08 1:12 AM, in article
91391CA1-8D13-44B7-B730-FB128F80AAA5@xxxxxxxxxxxxx, "Online User"
<OnlineUser@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I am comparing tools for synchronizing databases. The best I have found so
far is SQL compare from Red-Gate. Does the community have any suggestion on
other products that may work that are not as expensive?

I simply need to be able to generate a script to outline the changes that
were taken from one version of a db to the next.

thanks for any feedback



.

Relevant Pages

  • Re: Sync Schema for Two Databases.
    ... You can also look at Diff from www.apexsql.com ... ... You can script the objects in the two databases yourself (with the ... features available in Management Studio), compile the results into a single ... But never underestimate the cost of your time, not only when you do it ...
    (microsoft.public.sqlserver.tools)
  • Re: [DOC] Linux kernel patch submission format
    ... > | So, in addition to producing the difference, diff also asks you all the ... beneficial to have a script that everyone uses which enforces all the rules. ... well how computers can be used as tools to automate processes, ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Need ideas on how to parse output from "diff" cmd in a script
    ... Then I have a second ksh script that does a sequence of "diff" ... because of a date-processed timestamp in the report headers. ... By jcorn ...
    (comp.unix.shell)
  • Re: Command to dump/restore user info OSR5
    ... Write a script that does a dump and then compares the current dump against the previous such dump. ... You don't have a diff unless you install the devsys or gnutools. ... The order of the filenames on the diff command line, and the way the script renumbers filenames, means that the first instance is the old password and the next instance is the new password. ...
    (comp.unix.sco.misc)
  • Re: Tool for.....
    ... You may want to take a look at SQL Compare from Red Gate: ... Check the following article for a script to compare ... >Is there a tool that will return the discrepancies between two databases? ... >These are databases created for commonly used MS business solution products. ...
    (microsoft.public.sqlserver.tools)