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.
| Author |
Topic |
|
jesus4u
Posting Yak Master
204 Posts |
 Posted - 2002-08-20 : 15:55:55
|
| How can I distribute my WHOLE database including stored procedures and the tables with the data?ThanksI tried scripting the db but it didn't grab the existing data just the tables. |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-08-20 : 16:03:57
|
| You could use backup/restore or detach/attach. You could also ship data as .csv files or any other format and bcp in the data during setup.BUT, if you really want to script data in the form of INSERT statements, try my stored procedure sp_generate_inserts. Get it from: http://vyaskn.tripod.com/code.htm#inserts--HTH,Vyashttp://vyaskn.tripod.comEdited by - vyaskn on 08/20/2002 16:04:38 |
 |
|
|
|
|
|
Packaging my database