scripting

I am a developer working with an application that requires connections with
mulitple databases on their respective servers. My question is concerned
with updating the multiple databases to keep the schemas the same. I am
using scripts generate using the Create Script command in Enterprise Manager
to create a script to drop and create all the functions, views and procs and
that works without any problem. My question is how to deal with the tables.
Is there some method for automatically creating a script that will add
missing tables and modify exiiting ones based on the source tables
collection. I don't want to use drop and create as for the functions, etc,
because I will lose all the data in the tables. The database schemas must be
the same but the data in each is different. If I have to create the script
by hand, it is just as easy to modify the tables by hand so what I am looking
for is a command that says, "make all the tables the same"
JB
JB
http://www.karaszi.com/SQLServer/info_generate_script.asp
"JB" <JB@.discussions.microsoft.com> wrote in message
news:3126220C-6899-4EDB-92C5-F3CB34AC9017@.microsoft.com...
>I am a developer working with an application that requires connections with
> mulitple databases on their respective servers. My question is concerned
> with updating the multiple databases to keep the schemas the same. I am
> using scripts generate using the Create Script command in Enterprise
> Manager
> to create a script to drop and create all the functions, views and procs
> and
> that works without any problem. My question is how to deal with the
> tables.
> Is there some method for automatically creating a script that will add
> missing tables and modify exiiting ones based on the source tables
> collection. I don't want to use drop and create as for the functions,
> etc,
> because I will lose all the data in the tables. The database schemas must
> be
> the same but the data in each is different. If I have to create the
> script
> by hand, it is just as easy to modify the tables by hand so what I am
> looking
> for is a command that says, "make all the tables the same"
>
> --
> JB
|||You may find some of the Comparison tools useful. Most of them will compare,
and then create scripts to rectify the differences.
Object Comparison:
AdeptSQL Diff
AlfaAlfa Software - SQL Server Comparison Tool
ApexSQL - SQL Diff
Best SoftTool - SQL DBCompare
e-Dule - DB SynchroComp
PrimeLogics - DataVision 2007
Quest - SchemaCompare
RAC4SQL's QALite (Free)
Red Gate - SQL Compare
SQL Effects Clarity
TASC - SQL Delta
Teratrax Database Compare
TulsaSoft - SQL Examiner
Voltex Data Systems - SQLDBcontrol
XpressApps - sqlXpress Diff
xSQL Software - xSQL Object
Free Tools
RAC4SQL's QALite (Free)
SQL Effects Clarity CE Edition
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"JB" <JB@.discussions.microsoft.com> wrote in message
news:3126220C-6899-4EDB-92C5-F3CB34AC9017@.microsoft.com...
>I am a developer working with an application that requires connections with
> mulitple databases on their respective servers. My question is concerned
> with updating the multiple databases to keep the schemas the same. I am
> using scripts generate using the Create Script command in Enterprise
> Manager
> to create a script to drop and create all the functions, views and procs
> and
> that works without any problem. My question is how to deal with the
> tables.
> Is there some method for automatically creating a script that will add
> missing tables and modify exiiting ones based on the source tables
> collection. I don't want to use drop and create as for the functions,
> etc,
> because I will lose all the data in the tables. The database schemas must
> be
> the same but the data in each is different. If I have to create the
> script
> by hand, it is just as easy to modify the tables by hand so what I am
> looking
> for is a command that says, "make all the tables the same"
>
> --
> JB