SQL Server distributed databases

Question

how to link two different database in same SQL Server instance and send queries between them

Saar · Accepted Answer · 2009-12-07 11:42:39Z

5

use like below.

DB1.dbo.TableFromDB1
DB2.dbo.TableFromDB2

DB - database

answered Dec 7, 2009 at 11:42

Saar

8,5225 gold badges33 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Darryl Peterson · Accepted Answer · 2009-12-07 12:46:07Z

1

Look at using synonyms "CREATE SYNONYM".

You can access the databases directly with a full path. But, that code will break if the database is ever renamed or changed.

Using a synonym, the code can remain unchanged; when the database moves, just update the synonym.

This can be useful when you have a test and production environment. The code does not have to change just because you move it from test to production and the database names do not have to be identical.

answered Dec 7, 2009 at 12:46

Darryl Peterson

2,2701 gold badge17 silver badges13 bronze badges

Collectives™ on Stack Overflow

SQL Server distributed databases

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related