February 20, 2008 at 9:31 am
How can i extract/export esp. Stored Procedures, Tables, Functions and Views into separate txt-files, but not one for one, i want all at the same time and i want the files for "views, stored procedure, functions and tables", so that i have all files in a separate txt-file, for working further. Maybe someone has also an idea for doing this with a VB-Script (procedure: on Double-click the vbs-file there were make folders (".\test\test2\stored procedure", ".\test\test2\functions" and so on) and in these folders there were copy the extracted files out of sql) --> sql -> files convert -> make folders -> copy files in folders (p.e.: stored procedure\dbo.test.sql -> dbo.test.txt -> ".\test\test2\stored procedure\dbo.test.txt"
Thx for help 🙂
February 20, 2008 at 1:09 pm
Paul,
Easier than VB script...
1. Open Studio Manager
2. Highlight the Database
3. Right-click Tasks/Generate Scripts
4. The Generate Scripts wizard will appear, hit next
5. Choose the 'generate all objects' box
Continue through the wizard
February 21, 2008 at 1:35 am
Thanks for your Reply, but how looks the Code behind the Wizard, or how can I put this code in VB-Script, 'cause I want to have it in VB-Script, it's to slow for me with the Wizard.
Can you help me?
February 21, 2008 at 8:02 am
The wizard doesn't show the raw scripting, Not sure how familar with Visual Studio but I found a step by step procedure in creating a scripting package
http://www.sqlteam.com/article/scripting-database-objects-using-smo-updated
February 22, 2008 at 6:35 am
Thx for Your Reply's. Someone other has gave me personally an answer and the functionality is perfect.
Thx 🙂
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply