Compare database on developer and enduser server

26 Aug 2005 11:29 AM

PawelR

Hello Group,
Sorry my english is very littel.
In my company I have two servers: first developer server (DevSvr)- for
developers and second server (MainSvr)to use for other emplooy - for user of
application.
One of databases was changed on DevSvr (add new tables, sp, indexes etc.).
How compare databeses on DevSvr and MainSvr (db structure) and create script
to alter database on MainSvr.

Thx PawelR

26 Aug 2005 11:35 AM

lutz.jahnke

try www.red-gate.com

Lutz

26 Aug 2005 12:51 PM

JT

Before you invest several hundred dollars in a schema comparison tool,
consider the option of using Enterprise Manager to generate scripts for each
DB to seperate folders and using a GPL tool like WinMerge to perform the
file comparisons. You can configure to list only scripts and individual
lines that are different.
http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/6def4020de112661/ff9cfe0c46abfa76

Also, if you are checking your scripts into Visual Source Safe, there is a
feature to perform file comparisons between projects.

Show quote

"PawelR" <pawelratajc***@poczta.onet.pl> wrote in message
news:ecxsuFjqFHA.3800@TK2MSFTNGP11.phx.gbl...
> Hello Group,
> Sorry my english is very littel.
> In my company I have two servers: first developer server (DevSvr)- for
> developers and second server (MainSvr)to use for other emplooy - for user
> of application.
> One of databases was changed on DevSvr (add new tables, sp, indexes etc.).
> How compare databeses on DevSvr and MainSvr (db structure) and create
> script to alter database on MainSvr.
>
> Thx PawelR
>

26 Aug 2005 2:38 PM

B.M

You can use my free tools SQLDBDiff, the first time you lunch the tool it is
in French you can easly switch to English version by clicking :
Taches/Options/Language

Here is the link (My site will be in English soon)
http://www.sqldbtools.com/Downloads.aspx?ProductId=1

I'm waiting for your comments and feedback

Show quote

"PawelR" <pawelratajc***@poczta.onet.pl> wrote in message
news:ecxsuFjqFHA.3800@TK2MSFTNGP11.phx.gbl...
> Hello Group,
> Sorry my english is very littel.
> In my company I have two servers: first developer server (DevSvr)- for
> developers and second server (MainSvr)to use for other emplooy - for user
> of application.
> One of databases was changed on DevSvr (add new tables, sp, indexes etc.).
> How compare databeses on DevSvr and MainSvr (db structure) and create
> script to alter database on MainSvr.
>
> Thx PawelR
>