ms sql 2000 - create update script

[Jaros³aw Kozik]

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]

[Erland Sommarskog]

Re: ms sql 2000 - create update script

Jaros³aw Kozik (jkozik@op.pl) writes:

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 ... )

I'm sorry, but I don't understand what you are trying to achieve. Could
you clarify?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Thomas Arthur Seidel]

Re: ms sql 2000 - create update script

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]

[Jaroslaw Kozik]

Re: ms sql 2000 - create update script

I'v got two databases old and new one. I'm trying to generete diferential
script to update old databese structure to new database structure without
deleting existing data in old database

in this way I can only creata script which make new database
all tasks -genetate sql script .... ( CREATE Database SCRIPT ... )


Uzytkownik "Erland Sommarskog" <esquel@sommars kog.senapisal w wiadomosci
news:Xns9AE0EED AFE62Yazorman@1 27.0.0.1...

Jaros³aw Kozik (jkozik@op.pl) writes:

>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 ... )

>
I'm sorry, but I don't understand what you are trying to achieve. Could
you clarify?
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
>
Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

>

[Erland Sommarskog]

Re: ms sql 2000 - create update script

Jaroslaw Kozik (jkozik@op.pl) writes:

I'v got two databases old and new one. I'm trying to generete diferential
script to update old databese structure to new database structure without
deleting existing data in old database
>
in this way I can only creata script which make new database
all tasks -genetate sql script .... ( CREATE Database SCRIPT ... )

There is nothing built in, but there is very a popular third-party product
for the task. Go to http://www.red-gate.com and get a copy of SQL Compare.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Jaroslaw Kozik]

Re: ms sql 2000 - create update script

I'm trying SQL compare software and I can't generate differential script -
can I do it in this software
I see all difference between both databases but that's all


Uzytkownik "Erland Sommarskog" <esquel@sommars kog.senapisal w wiadomosci
news:Xns9AE1D7C B1251CYazorman@ 127.0.0.1...

Jaroslaw Kozik (jkozik@op.pl) writes:

>I'v got two databases old and new one. I'm trying to generete diferential
>script to update old databese structure to new database structure without
>deleting existing data in old database
>>
>in this way I can only creata script which make new database
>all tasks -genetate sql script .... ( CREATE Database SCRIPT ... )

>
There is nothing built in, but there is very a popular third-party product
for the task. Go to http://www.red-gate.com and get a copy of SQL Compare.
>
--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
>
Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

>

[Jaroslaw Kozik]

Re: ms sql 2000 - create update script

I've got it ;) it's SQL Packager 5 - this software generate executable file
with differential script

Thank you very much

[IJKK]

[dvdtknsn]

Re: ms sql 2000 - create update script

On Jul 20, 9:31 pm, "Jaroslaw Kozik" <jko...@op.plwr ote:

I'm trying SQL compare software and I can't generate differential script  -
can I do it in this software
I see all difference between both databases but that's all
>

Hi Jaroslaw,

In SQL Compare, if you click on the "Synchroniz e Wizard..." button in
the toolbar, click "Next", "Next", then "View SQL Script...", you
will be able to view the differential script.

Hope this helps,

David Atkinson
Red Gate Software