| Author |
 Topic  |
|
|
jezemine
Flowing Fount of Yak Knowledge
USA
2871 Posts |
 Posted - 10/22/2006 : 11:56:20
|
Just a quick note to let you all know about a (free) app I wrote that will script all the objects and (optionally) data in any 2000 or 2005 database.
It creates a separate file for each object, in a directory tree structure similar to that in Object Explorer in SSMS. It's very useful for getting your database scripts under source control if they are not already.
I posted the source as well so you can easily modify it to meet your needs if you know a little C#.
You can get it here:
http://www.elsasoft.org/tools.htm
hope it's useful to some of you!
SqlSpec - a fast, cheap, and comprehensive data dictionary generator for SQL Server 2000 and 2005 - http://www.elsasoft.org |
|
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
|
|
madhivanan
Premature Yak Congratulator
India
22460 Posts |
Posted - 10/22/2006 : 22:40:20
|
You should have posted it in Yak Corral Forum
Madhivanan
Failing to plan is Planning to fail |
 |
|
|
jezemine
Flowing Fount of Yak Knowledge
USA
2871 Posts |
Posted - 10/23/2006 : 02:59:46
|
I admit I'm a noob when it comes to the forums here. But isn't the Yak Corral more for informal stuff not necessarily related to sql server? I thought this might be of interest to sql devs, so I put it here.
Feel free to move it if you are moderator :)
SqlSpec - a fast, cheap, and comprehensive data dictionary generator for SQL Server 2000 and 2005 - http://www.elsasoft.org |
|
|
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
Posted - 10/23/2006 : 03:48:01
|
ok i've just read your bio jesse and i must admit that based on your nick i thought you were a woman 
my apologies
Go with the flow & have fun! Else fight the flow 
blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
jezemine
Flowing Fount of Yak Knowledge
USA
2871 Posts |
Posted - 10/23/2006 : 10:14:05
|
quote:
Originally posted by spirit1
ok i've just read your bio jesse and i must admit that based on your nick i thought you were a woman
lol!
I use jezemine because it's a nickname I got in high school. not sure why. I make for a pretty ugly woman.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator for SQL Server 2000 and 2005 - http://www.elsasoft.org |
|
|
|
rockmoose
SQL Natt Alfen
Sweden
3279 Posts |
Posted - 11/02/2006 : 16:44:32
|
Had an opportunity to try the tool.
Quite good!
rockmoose |
|
|
|
jezemine
Flowing Fount of Yak Knowledge
USA
2871 Posts |
Posted - 11/16/2006 : 03:18:38
|
quote:
Originally posted by rockmoose
Had an opportunity to try the tool.
Quite good!
rockmoose
thanks!
SqlSpec - a fast, cheap, and comprehensive data dictionary generator for
SQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
|
jezemine
Flowing Fount of Yak Knowledge
USA
2871 Posts |
Posted - 02/03/2007 : 17:28:50
|
just to let you know that I added a .bat file to the download that will loop through the generated scripts and execute them against a db/server that you specify.
so now you can extract the ddl using scriptdb.exe, and execute it using builddb.bat. it's just an example - feel free to improve upon the bat - and if you do let me know so others may benefit.
http://www.elsasoft.org/tools.htm
www.elsasoft.org |
|
|
| |
Topic |
|
scriptdb
