Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Extracting things from SQL Server
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00759133
Message ID:
00759344
Views:
20
This message has been marked as a message which has helped to the initial question of the thread.
>Hi.
>
>Is there any small app available out there that reads a given DB inside SQL Server and extracts things like SPs, UDFs, Triggers, etc, and put them into individual text files somewhere?
>
>Yeah, I know that that's not a hard thing to write, but I wonder whether someone haven't came up with such a thing yet. :)
>
>TIA

Claudio,

Have you looked at possibly using SQLDMO? Anything that you can do in the Enterprise Manager, you can automate with SQLDMO.

If your interested, Andrew Coates did a session on it at Whilfest. His presentation is included in the downloads.
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform