 Should I consolidate my databases? Opinions needed! [message #315356] |
Mon, 21 April 2008 05:03  |
basegreen328
Messages: 1
Registered: April 2008
Location: United Kingdom
|
Junior Member |
|
|
I am independant software vendor who is looking to move my product to run on an Oracle platform. Currently, I run on an MSSQL platform.
Firstly a quick overview of the product. It is a document management and workflow system that utilises (in MSSQL) two databases, one to control the lifecycle of the documents we store and their location (we dont store the documents in the database) and the other to control a) the active workflow lifecycle and b) contain the actual document related data.
The primary reason that I have two databases at the moment is really down to how the company / product has evolved. The workflow was introduced later and it was felt that to minimise risk (we had a good solid working product) to leave it alone...we are a small company (< 40 people) and resources are limited.
To migrate to an Oracle environment, I note that architecture is different with regards the concept of instance / database over what Microsofts is. To this end, I am wondering whether I should be looking to carry over the architecture above or to consolidate my applications in to a single instance / database.
What is everyones take on this. What are the advantages / disadvantages?
I'm really looking to get as much information as possible so any thoughts / opinions you may have will be greatly received.
Also - any questions, feel free to ask.
I Look forward to you responses...
|
|
|
|
|
|
|
|
| Re: Should I consolidate my databases? Opinions needed! [message #317824 is a reply to message #315356] |
Sat, 03 May 2008 22:43  |
TheSingerman
Messages: 49
Registered: April 2008
Location: Brighton, Michigan
|
Member |
|
|
One Instance/ One Owner(schema). For one thing, this is what your Oracle customers will expect and want.
I'm a little more concerned with the differences between Oracle's concurrency model and Microsoft's. I'm guessing that it is normal to have two users working on the same document at the same time. The same Microsoft code which keeps one user from stomping on the work of another may not work with Oracle. And, if you play any games to prevent lock escalation -- the good news is that there is no such thing in Oracle. The bad news is that those games may be counter productive.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
