How to link two sql servers

[danjapro]

How would i link two sql databses to allow them to share certain tables.

Example:

database 1 linked to database two and share customer table.

 

[ignoreme]

Look at Replication. There are plenty of wizards inside MSSQL. SQL Server has the ability to publish data between two servers. You can setup the rules, triggers, and so forth.

Good luck!

 

[danjapro]

Give me a little assistance in how this can be done.

My problem is I am using a .net shopping cart and I want to be able to have many cusotmers input and login into the shopping cart but I wasnt the custoemrs table in its own database.

 

[ecobb]

You should probably set the two up as Linked Servers, that way one database could actually query the other one, almost like it does it's own tables.



Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[danjapro]

How would I link them that was my main question.

 

[ecobb]

Oh, sorry. Check out "Linked Servers" in BOL.

You can set them up by looking under "Linked Servers" in the "Security" folder under your database in Enterprise Manager, or you can create them using Query Analyzer.

Maybe this will help:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp

Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher