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 |
|
KJensen
Starting Member
12 Posts |
 Posted - 2009-08-26 : 07:53:40
|
| So in SQL Server 2008 it is possible to script data from SQL Server Management Studio. Works great, love it etc.I would like to make a job, that scripts everything in my database (tables, stored procedures etc) to one file and all data in some tables to another.Is it possible - and what is the easiest way to do it?The reason why I want this is so I can put my development databases under source control and keep an easy to review history of changes. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-27 : 09:55:06
|
| You can try this command line utility: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73884And use BCP to extract the data into files.I don't know of any built-in command line utility in 2008 (there was one in v2000).Also, there are some 3rd party tools that will let you script the objects (ApexSQL, etc). |
 |
|
|
KJensen
Starting Member
12 Posts |
Posted - 2009-08-28 : 05:29:46
|
| Brilliant! Thanks! :) |
|
|
|
|
|
|
Automated scripting of database with data