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]

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@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

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]
>
>
>
>
>
>

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@sommarskog.se> napisal w wiadomosci
news:Xns9AE0EEDAFE62Yazorman@127.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@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
>

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@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

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@sommarskog.se> napisal w wiadomosci
news:Xns9AE1D7CB1251CYazorman@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@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
>

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

Thank you very much

[IJKK]

On Jul 20, 9:31*pm, "Jaroslaw Kozik" <jko...@op.pl> wrote:
> 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