William Sanders <> wrote: > Heya Matthew - > > Well - there *IS* a stupid tool - it resides inside o Enterprise > Manager. > You got EM loaded up properly and can run it from your workstation OR > the server ? > > Click on a database to select it > Then right click on it - look for 'GENERATE SQL SCRIPT' > > Crickey - now I feel stupid - thats not the right thing to call it. > But - there is an option to script out the database in its entirety - > and it IS a right-clicky thing.
I'm LMAO there Bill. Ok, EM into your db of choice. Go to a table in it and modify. That is the right clicky here but use Design. A bunch of icons now pop up on the top of the EM menu. 4th from the right is Generate SQL Scripts. There is a button on the right side Show ALL. Click on it. Now you can see the other check boxes will now work and you can select ALL. But why go through all this crap. Make a f'n backup of it and your there. Because this scripting is schema and not data. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 "Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." Dr. Martin Luther King Jr. http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.13.20/508 - Release Date: 10/31/2006 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
