Explain to me how to cross database servers from different networks?

Answer 1

If you're using SQL Server, create "Linked Servers" for each server that you want to access.

After that you'll just prefix the table names in your selects with the servername.database.owner

For example

select *
from server1.db1.dbo.table1 as t1
join server2.db2.dbo.table2 as t2
on t1.colx = t2.coly

Answer 2

Kim, initiate with a corporation plan. making plans in strengthen may assist you to ward off many uncomplicated blunders. maximum startups and small agencies choose no longer purchase or hire a server. There are literally tens of millions of servers obtainable to your use as a provider at a value far decrease than the fee to purchase and shelter your guy or woman. Google on my own has over 900,000 servers obtainable to your use. I propose you sign in your area and set up Google Apps. save your information interior the cloud, the place it particularly is secure by using international classification secure practices that no small corporation can locate the money for. I additionally might ward off paying for workstations till you incredibly need to place in community application. each worker who would not truthfully require regionally put in application ought to get a Chromebook, which will extremely simplify and shrink your administration, upkeep, and value. Chromebooks are low-fee than many workstations at around $3 hundred to $500. With Chromebooks, you do no longer pay Microsoft $200 to license dwelling house windows, you do no longer ought to problem approximately antivirus, back ups, continuously patching your application, and so on. and that they circulate from off to the internet in decrease than 10 seconds. there are various off the shelf suggestions for ecommerce as a provider, yet that's yet another question. permit me understand if i may assist you to.