Deploying stored procs, functions, tables

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Deploying stored procs, functions, tables

Author

Topic

boggyboy
Yak Posting Veteran

57 Posts

Posted - 2010-04-05 : 22:00:40

I've done a ASP.net application and now i want a easy way to deploy the various stored procs, tables, and sql functions that come with it.

Currently i create functions, tables, and sps one at a time,such as below

CREATE TABLE foo (
[id] [uniqueidentifier] NOT NULL,
[field1] [datetime] NOT NULL,
--and so on

Create function bar
(@fieldUID uniqueidentifier ,@field2 datetime)
returns decimal(18,2)
as
begin
--code here
end

create procedure hello
--parameters
as
begin
--code
end

but now i need a way to merge all of it into a single document. How do i do that???

Nick W Saban

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-05 : 22:30:33

You can script them all out into a single file using the generate SQL script wizard. It's a right-click away.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

boggyboy
Yak Posting Veteran

57 Posts

Posted - 2010-04-06 : 06:47:25

So easy i feel guilty! thanks!

Nick W Saban

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-06 : 14:35:22

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2011-01-24 : 16:54:00

You may need something for Tables since you need the 'delta'. We use Red Gate's SQL compare. But without a tool you could generate both scripts from your source and target Databases then use Word to do a text compare.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources