For updating a data base (left: Developers latest output, right: Customers data
base), we use "RedGate". That is a commercial program. Not cheap, not simple, but
until now I have not found anything better. What a shame.
One of the tricks to use that program is, to first do all the table extensions (a
good developer will never delete a column, and will never redefine an existing
column. So only new columns will be added). Depending on the size of the customer
data base, this can take a while. In a second action, compare and modify other
structure parts, like Stored Procedures, and finally indexes.
Redgate is not for free, but reliable. All scripts it creates will be kept on
demand, and you can edit them, and run them separately.
Sometimes I also use dbmgr2k, which is a freeware. It does have also a GENERATE
SCRIPT function. Such a script can for example create a table. It can also create
"Insert Into" scripts, which are very useful to update some initialisation table
contents.
TS
Jarosław Kozik wrote:
how to create script - update database development code using MSSQL 2000
Enterprise Manager
i'm trying in this way
all tasks -genetate sql script .... ( in this way I can generate only
CREATE Database SCRIPT ... )
[ IJKK]