|
Home > Archive > User Profile Management > June 2004 > Using DB2 for read operations, SQL Server for write?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Using DB2 for read operations, SQL Server for write?
|
|
| Niklas 2004-02-12, 12:36 am |
| Hi,
anyone have any experience using the profile system where
you separate read and write operations?
We have a DB2 database where most of the profile data is
stored and a SQL Server for the web specific profile data.
The problem is that we can't use the DB2 for both
read/write due to security/availability reasons.
So, we want to read all the DB2 profile data as it is and
write the corresponding data to another DB2 store.
The "shadow" store propagates the inserted data to the
original DB2 store for subsequent reading operations.
Has anyone had the same problem scenario?
| |
| James Walters [MSFT] 2004-06-28, 7:29 pm |
| For best performance it would be best to deploy a SQL Server for Profiles
one for DW, and one for the rest of the resources.
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
|
|
|
|
|