asked on

Automated script generation

Bit of a conundrum here. SQL server management studio has a generate scripts function that allows you to script any operation that it performs, except one. It doesn't offer the ability to script the script generation function.

We run an in-house developed reporting system that downloads its static data overnight and its dynamic data from the live server on an ad-hoc basis. Due to the fact that the data is refreshed daily the data itself does not require backing up, however the database structure itself represents quite a large investment of time and resources.
I've been able to capture this structure via the script wizard but have so far been unable to automate the script generation process so that it can be backed up without the multi-gigabyte overhead of the data. I'm looking to do it through integration services if possible?
any help would be much appreciated.
CBdarchem

ASKER CERTIFIED SOLUTION

chapmandew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

jorge_toriz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cbdarchem

ASKER

I'll have a look at these today guys - i've been off ill the past few days.
Many thanks,
Cbdarchem

cbdarchem

ASKER

The SSIS package was exactly what I was looking for, I ran a testbed and its spot on. The code snippet from jorge should be helpful too.
Thanks guys,
cbdarchem