473,549 Members | 2,835 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 4190
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****@sommarsk og.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****@sommars kog.senapisal w wiadomosci
news:Xn******** *************@1 27.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****@sommarsk og.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****@sommarsk og.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****@sommars kog.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****@sommarsk og.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.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
Jul 25 '08 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
2305
by: jason | last post by:
Is there a way - possibly a disconnected rs? - to update the contents of an existing pulldown on a page without having to re-submit the page for the user to see the pulldown populated with an additional value? I realise there are javascript possibilities (and I am still searching for a usable one) but I thought perhaps it may be possible to...
6
6756
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used the SQL Profile to watch the T-SQL-Command which Access ( who creates the commands?) creates and noticed:
3
6262
by: Doug Baroter | last post by:
Hi, One of my clients has the following situation. They use Access DB for data update etc. some business functions while they also want to view the Access data quickly and more efficiently in SQL Server 2000. Huge Access db with over 100 user tables, over 60 MB data. The DTS package that comes with SQL Server 2000 seems pretty "messy"...
1
2535
by: compraj | last post by:
I was using the SQL 2000 stored procedure wizard to create stored procedures. I can create insert, delete and update SPs however I am not able to create the select SP. The wizard does not offer the option of selecting "select" type SP. thank you for your replys compraj
4
3620
by: Glen A Stromquist | last post by:
I have a 6.5 db that I want to create a copy of, I can move it to either a machine running 7 or 2000. I am more used to doing this in Oracle so pls bear with me... I don't want to have any downtime on the 6.5 db, so I'm thinking perhaps import is the best way to go? I am assuming that 6.5 backups are not comaptible with either 7 or 2000...
5
3519
by: Neil Rutherford | last post by:
During testing of an application, i noticed a difference between SQL 2000 and SQL 7, both with identical config. In a nutshell: A table has a trigger for UPDATE and DELETE. When a column in the table is UPDATED the following happens: In autocommit mode, when entering a trigger the trancount equals 1 for both SQL 7 and 2000.
2
1665
by: abefuzzleduser2 | last post by:
I am using sql 2000 (mdb) with linked tables on SQL 2000. I need to use views to limit users records, instead of direct table access. I setup a single talbe view in sql and tested update and inserting the view using query analyzer. But when I add that view as a "linked" table in access (windows db security dsn-less). Access does not allow...
3
3042
by: hussein | last post by:
'm not bale to run my projec on the 2000 server, he error was: error while trying to run project: unable to start debugging on the web server.erver side error occurred on sending debug HTTP request mak sure that the server is running correctly . verify that there are o syntax errors in the web.config... i check the IIS, it is running...
1
3347
by: brian.j.parker | last post by:
One of the developers where I work found that some of his code would regularly cause index corruption in SQL Server 2000, post-sp4. @@version is 8.00.2050 and I can repeat this, so I can't (re-)apply the hotfix for KB article 929440. I know the code is not a good way to do what he's doing, which I explained to him. But corrupting the index...
0
7480
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7751
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7992
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7840
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6088
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3525
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3509
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1087
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
793
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.