469,903 Members | 2,050 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

ms sql 2000 - create update script

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]


Jul 19 '08 #1
7 4048
Jarosław Kozik (jk****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jul 19 '08 #2
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]


Jul 19 '08 #3
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" <es****@sommarskog.senapisal w wiadomosci
news:Xn*********************@127.0.0.1...
Jarosław Kozik (jk****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Jul 20 '08 #4
Jaroslaw Kozik (jk****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jul 20 '08 #5
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" <es****@sommarskog.senapisal w wiadomosci
news:Xn**********************@127.0.0.1...
Jaroslaw Kozik (jk****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

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

Thank you very much

[IJKK]
Jul 20 '08 #7
On Jul 20, 9:31*pm, "Jaroslaw Kozik" <jko...@op.plwrote:
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 "Synchronize 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
Jul 25 '08 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Glen A Stromquist | last post: by
2 posts views Thread by abefuzzleduser2 | last post: by
3 posts views Thread by hussein | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.