Genrate SQL Script

ioates · July 14th, 2003, 02:40 AM

I use this feature in EM and for documenting SPs. My question is can this feature be automatated with a SQL script. So that I can schedule to run with a Local Package/Job?

TIA - Ian

jesseleon · July 16th, 2003, 12:02 PM

Can you explain further "what" feature it is that your referring too?

Thanks,
Jesse

David Cameron · July 16th, 2003, 08:17 PM

I think he is talking about script generation from EM.

regards
David Cameron

David Cameron · July 16th, 2003, 08:26 PM

Aparently there is a script method in SQLDMO (which is an API to SQL Server). I don't know SQLDMO, but it might be worth looking into it.

regards
David Cameron

ioates · July 17th, 2003, 02:17 AM

Thanks, i'll investigate

Regards
Ian

ioates · July 17th, 2003, 05:51 AM

Thanks to DC for the pointer. I have come across the following VB example, within the SQL Server install directory

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Sqldmo\Vb\SQLScri pts

It is possible to change this vb program to dump a file with a date stamp affixed to the filename e.g. pubs20030717.txt, though it is just as easy to stick with the Generate SQL Script within EM.!!!