Jazz Register Log in
Jazz Forum Welcome to the Jazz Community Forum

Welcome to the Jazz Community Forum

 Connect and collaborate with IBM Engineering experts and users

Why separate databases instead of schemas for MS SQL with RTC?

Questions
Tags
Users
Badges
Mike Shkolnik
(980●9●161●143) Jun 24 '14, 1:19 p.m.
Our DBA wants to know why we have to have separate databases for RTC with SQL Server 2012? The instructions for Oracle use multiple schemas in the same database but the instructions for SQL, even with RTC 5.x which drops support for older than SQL 2012, still uses separate databases instead of schemas. MS SQL has supported multiple schemas since SQL 2005. Can someone please explain this?

0 votes

1 answer
5,273 views
0 votes

One answer

Permanent link
Grazielle Codogno
(153●1●6) Oct 09 '15, 6:08 p.m.
Hi Mike,

There's no other explanation for this, than Legacy!
For Oracle , my understanding it was an RFE opened to review this option to create database to create different schemas.
I believe the same can be done for SQLSERVER.

0 votes

Comments
Grazielle Codogno
Oct 09 '15, 6:08 p.m.

https://www.ibm.com/developerworks/rfe/

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 82
× 37
× 18

Question asked: Jun 24 '14, 1:19 p.m.

Question was seen: 5,273 times

Last updated: Oct 09 '15, 6:08 p.m.

Confirmation Cancel Confirm