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!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER