How to link to databases in MSSQL

Question

0.00/5 (No votes)

See more:

I need two databases in the same server to be linked.
So when changes have been made in database 1, it will affect the database 2 too.

What I have tried:

- I've tried linked servers but the databases isnt visible in the linked database.
- i also tried query to link tables instead but there are hundred of tables in my database so it is time consuming
- i encounter this https://support.office.com/en-us/article/import-or-link-to-data-in-an-sql-server-database-a5a3b4eb-57b9-45a0-b732-77bc6089b84e but this one is using MS Access and SQL server. But i want to the linking to be in between the MSSQL only

im using MSSQL Server Management Studio 2018

Posted 20-Oct-19 17:31pm

Member 14605491

Updated 21-Oct-19 2:47am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2019-10-20T21:14:00

Solution 1

Maybe this article will be helpful: Understanding SQL Server Linked Servers[^]

Also see: SQL Server Replication - SQL Server | Microsoft Docs[^]

If that does not help you might consider something like this: database-cluster-managers~symmetricds[^]

Posted 20-Oct-19 21:14pm

RickZeeland

Updated 20-Oct-19 21:20pm

v2

Herman<T>.Instance · Answer 2 · 2019-10-21T02:47:00

Solution 2

If you use the same USER for both database you can JOIN them in any Query sinces both database are IN the same server.
IE:
SELECT *
FROM [dbName1].[schema].[Table] as t1
JOIN [dbName2].[schema].[Table] as t2 on t2.<field> = t1.<field>

Posted 21-Oct-19 2:47am

Herman<T>.Instance