0

I use sql server 2005 as my database for my web application.... I generated scripts of the database by,

Database->Right Click->Tasks->Generate Scripts

I can script all my Tables,Stored Procedures,User Defined functions,Views,Users......

I have no data in it... I want the data to be scripted.. Any suggestion...

ACP
  • 149
  • 1
  • 5
  • 12

3 Answers3

0

I haven't tried it - but this appears to do what you want:

http://vyaskn.tripod.com/code.htm#inserts

The other alternative, though I'm not sure how viable it would be for you if you're wanting it completely scripted, would be to restore a backup of your old database, then transfer rows across to your new database. There's more info on this approach (partial restore) here: http://support.microsoft.com/kb/321836

Will
  • 408
  • 3
  • 8
0

Another option is to look into SQL Toolbelt. Their SQL Data Compare can script data. This of course hinges on the fact that you're ok spending money to get this done. http://www.red-gate.com/index.htm We use the entire SQL toolbelt where I work - some very useful tools in there.

If you do not wish to go this route - and your data in the pre-scripted database would not change then instead of scripting all the schema you could script the database creation and the restore of a backed up DB.

Dave Holland
  • 1,898
  • 1
  • 13
  • 18
0

SSMS 2005 does not have "Types of data to script" to deliver the desire scripts you wanted. you can install and use SSMS 2008 or later and then connect to your Sql Server 2005. "Types of data to script" will be available.

Bernie Naga
  • 1