Generate SQL Script using a DTS

#1

Hi

Each month I back up the structure of our databases by right-clicking
on each database and select Generate SQL Script...

Quote:

From the General tab I select script all objects and from the Options
tab I select script database, along with script indexes and script

primary keys.

As we have several databases this can take some time. Is there away to
automate this using a DTS?

Thanks
Matt

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts