Anonymous
Asked in
Cars &Transportation
ยท
2 weeks ago
How can I use two databases?
Contents
- Can I use 2 databases?
- How do I connect two databases?
- How can we use two databases to a single application?
Can I use 2 databases?
You can use two databases the same reason most banks have two ATMs, for reliability. You can swap one in if the other fails, but to do it quickly requires setup, such as a cname and controlling your own DNS server.
How do I connect two databases?
1. Create a linked server in DB invironment, then create a SP to take care of it. 2. Get two DataSets for them, then merge two datatables into one based on usersID.
How can we use two databases to a single application?
so, based on user login, the application should connect different database server. For Ex: if user "xxx" login with credential and belogs to "ABC" company and the database is "ABC", then ABC data need to display on the web page.
Related Questions
Relevance
-
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago
Write us your question, the answer will be received in 24 hours