Schema versus Database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Schema versus Database

Schema versus Database

Rate Topic

Display Mode

Topic Options

Author

Message

Narendra-587652

Posted Wednesday, December 22, 2010 5:11 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:10 AM
Points: 102, Visits: 259

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

Geoff A

Posted Wednesday, December 22, 2010 6:38 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:10 AM
Points: 485, Visits: 1,568

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

Grant Fritchey

Posted Wednesday, December 22, 2010 7:06 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 13,375, Visits: 25,159

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

Narendra-587652

Posted Thursday, December 23, 2010 5:21 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:10 AM
Points: 102, Visits: 259

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 »

Permissions