CODEWITHSUNDEEP
sql-server
jerbersoft
jerbersoft

Reputation: 4450

SQL Server: Script all DB objects (SP, Tables, Triggers, etc.) to SQL script

I would like to ask the experts here on how to script the database objects in SQL Server 2008 Express Edition. When generating scripts, I found out that only tables and triggers are available to be script. But how can the SPs be scripted too?

The problem is that I have a host provider and I wanted the database in my site to have ASP.NET membership framework objects (tables, SPs). It is a big disadvantage because my host does not allow remote access to their SQL Server.

I wanted my site's database to have objects of ASP.NET membership framework. What they allow is SQL scripts using "my little admin" tools.

Any help will be appreciated. If my question is not clear enough, please post a comment so I may revise the question.

Thanks!

Upvotes: 0

Views: 5695

Answers (2)

J.W.
J.W.

Reputation: 18181

I wanted my site's database to have objects of ASP.NET membership framework.

You can check out aspnet_regsql.exe command, which allows you to create all ASP.NET membership objects (tables/stored procedures) in the target database.

Also check out the Microsoft SQL Server Database Publishing Wizard

Upvotes: 0

Mitch Wheat
Mitch Wheat

Reputation: 300559

See this answer: Script all stored procedures in Management Studio 2005

Upvotes: 1

Related Questions