• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

Individual Scripts in SQL Server 2005

Hi All
I'm trying to script out all my Database objects into individual files but I can't seem to manage it with the interface. Does anyone have a workaround for this.

Regards,
0
homedaq
Asked:
homedaq
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
http://msdn2.microsoft.com/en-us/library/ms178078.aspx#

use the Generate SQL Server Scripts Wizard part. in the screens it has the option to generate 1 file per object
0
 
homedaqAuthor Commented:
Thanks for the quick response
Sorry maybe I'm missing something silly but where exactly on the wizard. I just can't see it.

Regards,
0
 
ptjcbCommented:
I don't see it either.

I did find this web link and it does what you need:
http://weblogs.sqlteam.com/billg/archive/2005/11/22/8414.aspx

Be sure to open it with Internet Explorer
0
 
homedaqAuthor Commented:
Cool Thanks. It works!
0
 
BanthorCommented:
I have seen that functionality in one version of SQL Server.
But not in Developer on XP.
Most Frustrating.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now