Click here to Skip to main content
14,327,470 members
   

Database

 
AnswerRe: Help with simple database Pin
Eddy Vluggen14-Mar-19 23:17
mveEddy Vluggen14-Mar-19 23:17 
AnswerRe: Help with simple database Pin
Mycroft Holmes15-Mar-19 12:49
memberMycroft Holmes15-Mar-19 12:49 
PraiseRe: Help with simple database Pin
Peter_in_278015-Mar-19 14:20
professionalPeter_in_278015-Mar-19 14:20 
GeneralRe: Help with simple database Pin
Mycroft Holmes15-Mar-19 14:57
memberMycroft Holmes15-Mar-19 14:57 
QuestionOracle database USER and SCHEMA [SOLVED] Pin
Valentinor11-Mar-19 9:16
memberValentinor11-Mar-19 9:16 
AnswerRe: Oracle database USER and SCHEMA Pin
CHill6012-Mar-19 22:45
protectorCHill6012-Mar-19 22:45 
GeneralRe: Oracle database USER and SCHEMA Pin
Valentinor13-Mar-19 1:30
memberValentinor13-Mar-19 1:30 
GeneralRe: Oracle database USER and SCHEMA Pin
CHill6013-Mar-19 2:23
protectorCHill6013-Mar-19 2:23 
In my own experience, having tables with the same name in two different schemas on the same database has led to issues (when people writing queries have omitted the schema name when referring to the table).

If there is absolutely nothing in common between the databases then I would probably have two separate databases and manage them separately. It rather depends on how things like backups, transaction logs, etc will be handled and if there are benefits to having the schemas held on the same db.

However, if these apps are for the same corporation and use different tables then I would put them on the same database, no need for differentiating schemas and users unless you want to use them to control access, or might want to in the future.

We are currently using schemas in a corporate database to indicate which "area" (application if you like) "owns" the data in the table(s) and using the dbo schema for common data (i.e. no tables with the same name in different schema). I'm yet to discover if this will cause us problems.

As you can probably gather .. "good" or "bad" is quite subjective and depends greatly on what the overall infrastructure is going to look like
GeneralRe: Oracle database USER and SCHEMA Pin
Valentinor13-Mar-19 3:04
memberValentinor13-Mar-19 3:04 
AnswerRe: Oracle database USER and SCHEMA Pin
Eddy Vluggen13-Mar-19 0:59
mveEddy Vluggen13-Mar-19 0:59 
QuestionDisplaying multiple rows into single row as columns based on id - Sql Server Pin
Member 111541886-Mar-19 20:18
memberMember 111541886-Mar-19 20:18 
SuggestionRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
CHill606-Mar-19 21:47
protectorCHill606-Mar-19 21:47 
AnswerRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Victor Nijegorodov6-Mar-19 21:52
memberVictor Nijegorodov6-Mar-19 21:52 
GeneralRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Member 111541886-Mar-19 23:24
memberMember 111541886-Mar-19 23:24 
AnswerRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Richard Deeming6-Mar-19 22:08
mveRichard Deeming6-Mar-19 22:08 
GeneralRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Member 111541886-Mar-19 23:21
memberMember 111541886-Mar-19 23:21 
GeneralRe: Displaying multiple rows into single row as columns based on id - Sql Server Pin
Mycroft Holmes7-Mar-19 10:50
memberMycroft Holmes7-Mar-19 10:50 
QuestionHelp me with caculate debit balace and incredit by SQL server 2012 Pin
Member 141737536-Mar-19 19:08
memberMember 141737536-Mar-19 19:08 
Rant[REPOST] Help me with caculate debit balace and incredit by SQL server 2012 Pin
Richard Deeming6-Mar-19 21:58
mveRichard Deeming6-Mar-19 21:58 
QuestionSQL Access: Calculate the total elimination of records not the same month and year ? Pin
Member 24584674-Mar-19 21:26
memberMember 24584674-Mar-19 21:26 
QuestionQuery Question Pin
milo-xml1-Mar-19 2:14
professionalmilo-xml1-Mar-19 2:14 
AnswerRe: Query Question Pin
Afzaal Ahmad Zeeshan1-Mar-19 3:19
mveAfzaal Ahmad Zeeshan1-Mar-19 3:19 
GeneralRe: Query Question Pin
milo-xml1-Mar-19 5:31
professionalmilo-xml1-Mar-19 5:31 
GeneralRe: Query Question Pin
Afzaal Ahmad Zeeshan1-Mar-19 7:46
mveAfzaal Ahmad Zeeshan1-Mar-19 7:46 
GeneralRe: Query Question Pin
milo-xml1-Mar-19 8:05
professionalmilo-xml1-Mar-19 8:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.