Hi,

I have finished my Database along with Tables, Views, Stored Procedures
and Constraints.

Is there an easy way to push 1 button ;-) that will export the complete
database into a SQL Script? I want to add this to the root of the
application so I can easily setup other DB in the future?

I know you can do it per table, but 1 big file?

Thanks in Advance.

Daren

Backup...

Covers everything and no messy scripts.
"Daren Hawes" <Newsgroups (AT) webdesignmagic (DOT) com.au> wrote

Hi,

I have finished my Database along with Tables, Views, Stored Procedures and Constraints.

Is there an easy way to push 1 button ;-) that will export the complete database into a SQL Script? I want to add this to the root of the application so I can easily setup other DB in the future?

I know you can do it per table, but 1 big file?

Thanks in Advance.

Daren

Hi Darren,

That seemed to work. Had a few errors after parsing but will need to
investigate further. Any way of formatting the script?

I am using MS SQL 2000 and just pasting into Query Analyser. Any other
ways? The DDL is just 1 long line. Any Ideas?

Thx

_____

From: Darren Green [mailto:darren.green (AT) reply-to-newsgroup-sqldts (DOT) com]
Posted At: Friday, 21 January 2005 1:11 AM
Posted To: microsoft.public.sqlserver.dts
Conversation: Exporting Script of complete Database
Subject: Re: Exporting Script of complete Database


Backup...

Covers everything and no messy scripts.

"Daren Hawes" <Newsgroups (AT) webdesignmagic (DOT) com.au> wrote

Hi,

I have finished my Database along with Tables, Views, Stored Procedures
and Constraints.

Is there an easy way to push 1 button ;-) that will export the complete
database into a SQL Script? I want to add this to the root of the
application so I can easily setup other DB in the future?

I know you can do it per table, but 1 big file?

Thanks in Advance.

Daren

Sorry, you've lost me entirely. I suggested a backup which doesn't produce any scripts, just a single backup file of everything, which you restore.


--
Darren Green
http://www.sqldts.com
"Daren Hawes" <Newsgroups (AT) webdesignmagic (DOT) com.au> wrote

Hi Darren,

That seemed to work. Had a few errors after parsing but will need to investigate further. Any way of formatting the script?

I am using MS SQL 2000 and just pasting into Query Analyser. Any other ways? The DDL is just 1 long line. Any Ideas?

Thx



------------------------------------------------------------------------------
From: Darren Green [mailto:darren.green (AT) reply-to-newsgroup-sqldts (DOT) com]
Posted At: Friday, 21 January 2005 1:11 AM
Posted To: microsoft.public.sqlserver.dts
Conversation: Exporting Script of complete Database
Subject: Re: Exporting Script of complete Database


Backup...

Covers everything and no messy scripts.
"Daren Hawes" <Newsgroups (AT) webdesignmagic (DOT) com.au> wrote

Hi,

I have finished my Database along with Tables, Views, Stored Procedures and Constraints.

Is there an easy way to push 1 button ;-) that will export the complete database into a SQL Script? I want to add this to the root of the application so I can easily setup other DB in the future?

I know you can do it per table, but 1 big file?

Thanks in Advance.

Daren