sql - Cross Database Queries vs Replication -


i have 2 sql 2008 database servers have database stored procedures cross database server queries (different physical servers. querying done through linked servers). i'm assuming not best practice want figure out way fix this. thought replication our database design prevents (some tables not have primary keys).

is there other options have not have cross server queries?

the problem not databases on server on server b.

symmetricds can replication sql server (express, standard, or enterprise). not need have pks on tables. use columns tables without primary keys or have ability provide virtual keys use replication.

symmetricds overview


Comments

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

asp.net mvc - breakpoint on javascript in CSHTML? -