Re: Embedded Stored Procedure within App

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Spam Catcher wrote:
Hi all,

We have an application with is store procedure dependent. I'm looking for a
way to simplify our deployment by embedding Stored Procedures within our
application so that we do not have to "keep track" of which SPs to promote.
Basically if we can just "build and release" that will be idea.

So how do you guys manage your stored procedures? I'm thinking of two
possiblities:

1. Store the SPs in a the resouce file

2. Store the SQL scripts in a folder, then dynamically load the SPs when
they're needed.

I like Option #1 because all required SPs are deployed with the binary...
but editing a resource file is pain with the default VS.NET editor.

Option #2 provides a lot of flexiblity - we can modify SPs to suit certain
customer requirements... but synchronizing releases will be difficult.

Any other ideas?

Thanks!

I go with option 3:
Build a seperate Update utility that has ALL the stored procedures
(internally, as resources). then it can check the database to see which
updates have already been applied, then it applies the ones it needs.

.

Relevant Pages

  • Embedded Stored Procedure within App
    ... We have an application with is store procedure dependent. ... way to simplify our deployment by embedding Stored Procedures within our ... application so that we do not have to "keep track" of which SPs to promote. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Portable stored procedures
    ... > JDatastore lets you store binary streams outside the table scema. ... Other databases usually do not store BLOB's ... > you will have to write the function in the client in Java (or whatever ... >> stored procedures written in some proprietary language. ...
    (comp.lang.java.databases)
  • Re: Writing ONE STORED PROCEDURE rather than 5
    ... @StartDate DateTime = null, ... is null and @store is null ... > I have created the following 5 stored procedures which return rows based> on ... > select * from INVOICES ...
    (microsoft.public.sqlserver.programming)
  • Re: how to rollback a procedure (sqlserver) from VB2005?
    ... Maybe it is because I am simplifying some of the stored procedures (that I ... app than the whole procedure in sqlserver. ... running sql inline in the app. ... structure I could use to store the SPs in a more orderly fashion? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Could not find stored procedure dbo.aspnet_CheckSchemaVersion
    ... In order to use the database to store your membership information you need ... to provision it with the necessary tables and stored procedures. ...
    (microsoft.public.dotnet.framework.aspnet)