Kbase P124565: How to connect to two databases using the same schema holder?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/07/2007 |
|
Status: Unverified
GOAL:
How to connect to two databases using the same schema holder?
GOAL:
How to connect to several databases using the same schema holder?
GOAL:
How to work transparently on two databases with the same schema definitions
GOAL:
Example: Production database and test database
FACT(s) (Environment):
MS SQL DataServer
FIX:
Option 1: Databases on distinct instances.
In this solution both databases need to have the same name. Therefore they have to be installed on 2 different instances. It can be on two different machines or on the same machine with 2 instances of SQL server installed.
The user must have the same privileges to access both databases with the same schema holder. The privileges must be
Public AND Dbo