Windows in the Enterprise: SQL Server script creator

[Windows in the Enterprise: Best of myITforum]

Title: Windows in the Enterprise: Best of MyITForum

August 05, 2004 Published by  TechTarget Windows in the Enterprise: Best of MyITForum Issue Sponsored By:   > Altiris   Altiris Application deployment is one of the most significant challenges IT professionals face. To ensure successful deployment, smart organizations use Wise Package Studio to reduce packaging time by 50%, reduce Windows Installer migration time by 60%, and achieve return on your Wise Package Studio investment in as little as one month. Read the white paper to learn more.   SQL Server script creator [ by Mike Linkey, contributor, myITforum.com ] Have you ever wanted a tool to run that will script your SQL Server databases? I did, and rather than spend lots of money on buying one, I wrote this simple program that allows you to select your server and database and script it out and save to a file. I have always been nervous since we have little documentation on databases in our office. This at least gives me some stuff for disaster purposes. As of right now, this application only creates the "CREATE only" scripts. In the future, it will do the "DROP only" and "CREATE/DROP" scripts. This will be as my time permits! Requirements: This application is written in VB.NET. You will need to have the .NET framework installed from Microsoft. I did not include it in the setup because it will make the size of the files huge. Once you have the .NET framework installed, then run the setup program. Once that is complete, then run the SQLScriptGenerator.exe file from the installation location. It is pretty simple after that. Note: If you are using SQL Server 7 and have Enterprise Manager loaded on your PC, you will need to re-apply the latest SP in order to fix an incompatibility problem. This application was designed using the SQLDMO.dll file from SQL Server 2000. If you happen to break it or get an error, send me an e-mail with as much detail as possible about what you were doing when it broke. Also send me a screenshot of the error and I will see what is going on. Send this info to my e-mail address Here is the link to the application This article first appeared in myITforum, the premier online destination for IT professionals responsible for managing their corporations' Microsoft Windows systems. The centerpiece of myITforum.com is a collection of member forums where IT professionals actively exchange technical tips, share their expertise, and download utilities that help them better manage their Windows environments, specifically Microsoft Systems Management Server (SMS). It is part of the TechTarget network of Web sites. To register for the site and sign up for the myITforum daily newsletter, click here ABOUT THE AUTHOR: Mike Linkey works in network administration for a government agency in Illinois. He has been in the IT industry for eight years and has his MCSE for Windows NT 4.0 and Windows 2000. Mike is also experienced in VB programming. MORE INFO:  >  The SQLScripter Utility Application  >  SQL Server forum stories - SQL Schema Export  >  Adding New Logins To Your SQL Server Database  >  Saving SQL Server Tables To Removable Media Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED] Free E-Newsletters! Select e-newsletters you would like to receive via e-mail! SearchWin2000: SQL Server Tip Not a Member? We'll activate your membership with your subscription. ABOUT THIS E-NEWSLETTER This e-newsletter is published by TechTarget, the most targeted IT media and events company. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "Windows in the Enterprise: Best of MyITForum": Go to unsubscribe: http://searchTechTarget.techtarget.com/u?track=NL-36 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact Us: TechTarget Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494