Link to home
Start Free TrialLog in
Avatar of PMH4514
PMH4514

asked on

SQL Server Object script generation to individual files?

Hello

I'm using SQLServer 2005 Express (for development but also have access to same DB on a 2008 Enterprise server)

I'm looking for a way to script every object in the database - with output going to individually named files. Is this possible? I see the Generate Scripts option but it dumps everything into a single file.

I'd like multiple files, named as the object name, so that I can start putting them all under revision control.

Perhaps somebody has a script that will perform this task?

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of deviprasadg
deviprasadg
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PMH4514
PMH4514

ASKER

that'll work! thanks