I have installed MDM 7.1 System on IBM AIX and connected to Oracle database. I have observed whenever we create Repositories MDM Created Table Spaces/ Data files under the one Oracle_SID that is how it should be . Now we had to install MDM on windows machines using with MS SQL DB. I have installed it and connected to MS SQL Server.
The problem is when ever we create or copy new repositories it is creating new database for each repository under MS SQL Server, Although we have created a separate SQL Database and mentioned the same name while initializing the database connection.
Example while connecting MDM For first time to the DB , I have used 4 schema options , Now if i create a new repository it is creating 4 Database instances under MS SQL DB. On oracle it will just create Table Spaces.
Is there any one who worked on MDM Using MS SQL DB. Is this a problem or This is how it works on MS SQL ?
Please help , I really appreciate your help.