May 2, 2017 at 10:10 am
Good afternoon,
I have a server named sqlexpress with a user table and another cpa server with a table with the same information. The sqlexpress server automatically updates and I want the user table of the cpa server to update whenever the previous one changes, how can I do this? The sql that I have is the sql server express 2014
May 2, 2017 at 10:30 am
bfmpinto - Tuesday, May 2, 2017 10:10 AMGood afternoon,I have a server named sqlexpress with a user table and another cpa server with a table with the same information. The sqlexpress server automatically updates and I want the user table of the cpa server to update whenever the previous one changes,
Within the user tables, I have six fields, where the primary key is id.
how can I do this? The sql that I have is the sql server express 2014
May 2, 2017 at 2:02 pm
bfmpinto - Tuesday, May 2, 2017 10:30 AMbfmpinto - Tuesday, May 2, 2017 10:10 AMGood afternoon,I have a server named sqlexpress with a user table and another cpa server with a table with the same information. The sqlexpress server automatically updates and I want the user table of the cpa server to update whenever the previous one changes,
Within the user tables, I have six fields, where the primary key is id.
how can I do this? The sql that I have is the sql server express 2014
If all of your SQL Servers are using the Express version of SQL 2014, you can use Transactional Replication (subscriber only). You'll have to look up the details, but it's usually fairly easy to set up. Just be sure that all the tables you want to replicate have a primary key.
Alternatively, you could use a trigger on each table, but that could take a lot longer to set up and might require Linked Servers and if there's much network delay between the two, that could be problematic in terms of insert performance.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
May 2, 2017 at 3:00 pm
Sorry for the question, but is it possible for you to put a real example or example with the information you gave me?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply