Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Schema versus Database Expand / Collapse
Author
Message
Posted Wednesday, December 22, 2010 5:11 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 11, 2013 5:11 AM
Points: 102, Visits: 261
We have three application in sql 2005 and we want to merge the data base
would like to know what is the advantage and disadvantage of

1) Have a separate database for all application

Or
2) Have 1 database for all application with separate schemas.

Post #1038190
Posted Wednesday, December 22, 2010 6:38 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 2:13 PM
Points: 514, Visits: 1,723
sounds like Oracle speak to me...

in SQL a database is what Oracle calls schema.
in SQL an instance is what Oracle calls a database.

so, to answer your question, each app should have there own 'database'

i only give apps their own instance IF they need to have access to the system databases. Ie master, msdb.... or if the app needs to be controlled from a resource perspective.
Post #1038229
Posted Wednesday, December 22, 2010 7:06 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:18 AM
Points: 15,620, Visits: 28,000
Before you put different applications within a single database, I'd check to see just how much cross-dependencies there are between the apps. Do they share tables & procedures? If so, you have a case for putting them into a common database. If they share nothing, or little, I'd keep them seperated because by putting them into a common database, you're going to tightly couple these apps and make it very difficult to develop them indepdent of each other.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1038252
Posted Thursday, December 23, 2010 5:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 11, 2013 5:11 AM
Points: 102, Visits: 261
thank's for the update
the application are isolated to each othere and they use maximum simillarer tabel and SP
but fee differnet tables also .
Post #1038709
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse