473,396 Members | 1,785 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Advice for grouping stored procedures?

2
I am preparing to upgrade a fairly large application, so I'm looking for some advice before I begin my design. I have quite a bit of experience in Oracle, but I am required to use SQLServer for data storage in this application. When using Oracle, it is easy to group related stored procedures into packages. In SQLServer; however, I don't seem to have that option. Any opinions on a good way to group code for easy maintenance and navigation (i.e. in Management Studio - I'd prefer not to see a list of several hundred stored procedures)? I've already thought about naming conventions, but I'd prefer a solution that is more like the Oracle package solution.
Dec 21 '07 #1
1 1089
iburyak
1,017 Expert 512MB
In SQL 2005 you can create a project and store all scripts for procs in it also you can use Schemas to group your database objects and rights to them.

Good Luck.
Dec 21 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Andy Reynolds | last post by:
I am looking for information, books, websites, etc that will help me figure out the following things in MSSQL and Oracle: 1. Optimizing the database configuration itself. 2. Optimal table and...
2
by: Kent Lewandowski | last post by:
hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered...
5
by: Tim Marshall | last post by:
I was following the thread "Re: Access Treeview - Is it Safe Yet?" with interest and on reading the post describing Lauren Quantrell's SmartTree, I've run into something I don't understand: Stored...
4
by: Me | last post by:
I am writing a C#.NET application that is primarily intended to be used with SQL server. One of my concerns is that in the future I will have users who do not have or want to run SQL Server. That...
1
by: Matt | last post by:
Hello, I'm working on a project in which i use Sql Server stored procedures to add and modify the records of our customers. This works fine, but when writing these stored procedures, i must use...
28
by: mooreit | last post by:
The purpose for my questions is accessing these technologies from applications. I develop both applications and databases. Working with Microsoft C#.NET and Microsoft SQL Server 2000 Production and...
1
by: C4rtm4N | last post by:
I'm about to embark on re-writing a database & bespoke web reporting application for our call centre & would like a little advice please. Currently the database has 10 tables containing summaried...
5
by: PJackson | last post by:
DB2 UDB 8.X on Windows server A couple of questions: 1.) I am trying to develop some DB2 SQL stored procedures. Dev environment at UDB v 8.2, production environment still at UDB v 8.1. Any...
14
by: Mo | last post by:
Hello All, I'm investigating moving some Access 2003 applications over to SQL Server 2005, using Access ADP as the front-end. It's would also be very important to use stored procedures and...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.