Single Data Base with Multiple Schemas

  • Hi, my name is Carlos, I'm using SQL Server 2012, and I have a situation, my boss wants to integrate every Data Base in one single, but I'm not sure 'cause maintenance will become hard. By example, One of those DBs, belongs to a real-state sales management (17 GB), another DB to a judicial processes management (5 GB), the backup time will increase, if something goes wrong with files or schemas, every Application will be afected.

    Well, my questions are:

    In which cases is recommended doing this centralization?

    What are the best practicess recommended?

    thanks for comments, regards.

  • If these are completely different functional applications with no shared data between them, then no, I would not put them into the same database. The sizes you're talking about are fairly small, so taking a 10gb database and making it 15gb is pretty trivial, so I wouldn't argue from that stand point. Instead, I'd worry about the fact that deployments to one application will affect the up-time and availability of the other. I'd worry about the fact that you've got users in the database that shouldn't have access to other apps, so now you have to get security set up differently within each database. As a general rule of thumb, if they're not sharing data, don't put them into the same database.

    Just a thought, is your boss an Oracle person? They refer to a database what would, on the SQL Server side, be basically an instance. So they think they need to jam everything into one db when they don't.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Thanks, I agree with you about performance, availability, and security. I most work in planing, and yes you're right, my boss worked with Oracle, at least 8 years.

  • Grant Fritchey (9/10/2013)


    ..

    Just a thought, is your boss an Oracle person?

    That was a very clever observation, also a time-saver 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply