June 18, 2010 at 11:59 am
Hi All,
I have 2 clients with SQL Server Express, one in place A and other in place B. Both clients have independents aplications and dont have comunications between them.
Now i need a solution for this: 🙂
I have another computer running another SQL Server Express in place C, have the both aplications installed on computer. One aplication to read a database from place A and another aplication to read a database from place B. This computer only have access to read information from both database.
I tried the replication method, but the SQL Server Express cant be a distribuiter (Place A and B).
Anyone have any ideias how can i replicate the databases from places A and B to place C?
King Regards
June 22, 2010 at 8:28 pm
Hi Simple answer is no, you can't replicate the data, SQL express can only be a subscriber. But seeing that you are only using express then the databases must be quite small. You could set up a scheduled windows task that backs up the databases on A and B and copies them to C where they are restored. This means that C will always be a bit behind, depending on how often you ship and restore.
Option 2
Quite trucky and would require a bit of work. Put a trigger on the tables for A and B and have them populate the data to C through a linked server. this could potentially be a lot of work, but an interesting project. Thre would be alot of checks that you would need to put in place. Only do this if the design of your databases is static and no future design changes.
June 22, 2010 at 10:46 pm
Option 2
Quite trucky and would require a bit of work. Put a trigger on the tables for A and B and have them populate the data to C through a linked server. this could potentially be a lot of work, but an interesting project. Thre would be alot of checks that you would need to put in place. Only do this if the design of your databases is static and no future design changes.
Good one.
We are restoring the daily diff backup and syncing the environment. You can try.
"More Green More Oxygen !! Plant a tree today"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply