Thanks Prema and Vaibhav. But I'm a bit confused. I'm using SQL Server Management studio.
I see an option to create DB and under the DB -->security, I can create a schema. so are you suggesting that I create one DB and under that create 3 different schema's --ED, IAM, Registry . One schema for each. If that is the case, when I configure the DB details in the site.prop and dradis.prop , Since I have to give the DB name in the connection string, how can I point to the specific schema in the DB for each of it.
or are you suggesting to create 3 DB and provide the name of each DB in the connection string. Attached a screen shot for your reference.
I'm not so well versed with the DB :-)
Regards,
Shivakumar
Original Message:
Sent: 10-29-2020 11:56 PM
From: Vaibhav Jain
Subject: DB Setup for DevTest Migration
Hi Shiva,
As the schemas will be different, you can use same DB for IAM & Registry.
Thanks
------------------------------
Regards,
Vaibhav Jain
Capgemini
Original Message:
Sent: 10-29-2020 05:08 PM
From: Shivakumar Dabbiru
Subject: DB Setup for DevTest Migration
Hi SupportListeners,
I'm doing DevTest Migration from 10.3 to 10.6 and would like to understand the right approach for setting up external DB for DevTest. I'm using SQL Server as External DB.
I understand that Enterprise Dashboard would need a dedicated DB instance. What I want to know is, Can the IAM and Registry use the same DB instance or do they also need to have separate DB instances each?. Will there be any conflict if we use the same DB instance for Registry and IAM?
------------------------------
Regards,
Shivakumar.
------------------------------