Generating Scripts for an Application

[Murali SN Rao]

Hi there..

We are developing an INtranet application using SQL Server 2000 and ASPs, we are looking for a way to Generate a Module wise Scripts(Database Scripts like Table Scripts / Stored Procedure / Triggers / Functions etc).

This facility exits in Oracle 8i. How can i do the same in SQL Server2000..??

When i say Application..I mean Our Application and When i say Module..I mean one of the Modules in the Application..

Does SQL Server 2000 have any utility to do the same..???

If I am able to do this..then the COde Maintainablility will be easier...

Thanx

regards
Murali

[MAK]

Did u happen to try scptxfr.exe

its located under the folder

Microsoft SQL ServerMSSQLUpgrade

u can create as job or dts and run from your asp by calling stored procedure

------------
Murali SN Rao at 5/8/2002 2:30:01 AM

Hi there..

We are developing an INtranet application using SQL Server 2000 and ASPs, we are looking for a way to Generate a Module wise Scripts(Database Scripts like Table Scripts / Stored Procedure / Triggers / Functions etc).

This facility exits in Oracle 8i. How can i do the same in SQL Server2000..??

When i say Application..I mean Our Application and When i say Module..I mean one of the Modules in the Application..

Does SQL Server 2000 have any utility to do the same..???

If I am able to do this..then the COde Maintainablility will be easier...

Thanx

regards
Murali