Need to create update patch - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Need to create update patch

Author

Topic

kamalcharan
Starting Member

1 Post

Posted - 2002-04-26 : 09:34:18

We need to develop an application which creats a patch for the database which when executed in the clients system, will automatically update the clients database. a snap shot of the requirement ...

1. Compare the database structures in a source database to a destination database and display differences in the following objects:
a. Tables
i. Indexes
ii. Triggers
iii. Default Values
iv. Primary and Foreign Keys
v. Constraints
vi. Data (if intended to be generic across clients)
b. Stored Procedures
c. Views
d. User Defined Functions
2. From these differences, SQL scripts need to be automatically generated that when applied will synchronize all the objects and bring the server up to the current version.
3. Individual update scripts must be generated for each object to be altered.
4. Output files must be generated using the naming standards used by Enterprise Manger when exporting several objects to individual files.

Any input on this will be higly appreciated.

Edited by - kamalcharan on 04/26/2002 09:38:11

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2002-04-26 : 09:52:00

Check out this link -

[url]http://www.sqlteam.com/redir.asp?ItemID=6585[/url]

I found it very helpful in flagging differences in two databases.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources