| Author |
Topic |
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
 Posted - 2006-10-22 : 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.htmhope 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
11752 Posts |
Posted - 2006-10-22 : 12:30:06
|
not bad.  Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-10-22 : 22:40:20
|
| You should have posted it in Yak Corral ForumMadhivananFailing to plan is Planning to fail |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-10-23 : 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
11752 Posts |
Posted - 2006-10-23 : 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
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-10-23 : 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
3279 Posts |
Posted - 2006-11-02 : 16:44:32
|
| Had an opportunity to try the tool.Quite good!rockmoose |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-11-16 : 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 forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-03 : 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 |
|
|
|
|
scriptdb