How to Generate Scripts for Database with Data

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 2005 Forums

Transact-SQL (2005)

How to Generate Scripts for Database with Data

Author

Topic

baburk
Posting Yak Master

108 Posts

Posted - 2009-04-27 : 00:49:03

Hi,

I want to generate script for the entire database along with data(i.e. with INSERT statement).

Is there is query?.

Thanks,
Babu Kumarasamy

svicky9
Posting Yak Master

232 Posts

Posted - 2009-04-27 : 07:35:51

In my experience...You may need to use SQL server Management Objects (SMO) http://msdn.microsoft.com/en-us/library/ms162169.aspx Or one of the RedGate tools should do it.

http://www.sqlserver007.com

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-27 : 08:49:13

Also refer http://vyaskn.tripod.com/code/generate_inserts.txt

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources