Loading

Switch Database Connection

Aniket Yadav

Hello,

I have one query.

I have one Master database in which i have the company id, password and the name of the connection string for other database.

For Eg:

Master Database:

CompanyID Password ConnStr

ABC0001 ****** MyNewConn1

ABC0002 ****** MyNewConn2

My question is can i switch from one database to another database taking the connection string from the master database and using that connection string for connecting to other database under same server?

Please Help Me....

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manikavelu Velayutham15y ago
If your credential has the permission to all database, you can do a cross database query in a single connection string
select * from database1..table1
select * from database2..table1
you can query cross database also like
select * from database1..table1 d1 join database2..table1 dt on d1.id = d2.id