SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 scriptdb
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 10/22/2006 :  11:56:20  Show Profile  Visit jezemine's Homepage  Reply with Quote
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
11750 Posts

Posted - 10/22/2006 :  12:30:06  Show Profile  Visit spirit1's Homepage  Reply with Quote
not bad.



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22754 Posts

Posted - 10/22/2006 :  22:40:20  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
You should have posted it in Yak Corral Forum

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 10/23/2006 :  02:59:46  Show Profile  Visit jezemine's Homepage  Reply with Quote
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
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11750 Posts

Posted - 10/23/2006 :  03:48:01  Show Profile  Visit spirit1's Homepage  Reply with Quote
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
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 10/23/2006 :  10:14:05  Show Profile  Visit jezemine's Homepage  Reply with Quote
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
Go to Top of Page

rockmoose
SQL Natt Alfen

Sweden
3279 Posts

Posted - 11/02/2006 :  16:44:32  Show Profile  Reply with Quote
Had an opportunity to try the tool.
Quite good!

rockmoose
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 11/16/2006 :  03:18:38  Show Profile  Visit jezemine's Homepage  Reply with Quote
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
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 02/03/2007 :  17:28:50  Show Profile  Visit jezemine's Homepage  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000