Manual SQL Replication

runtheworld_jw 21 Reputation points
2022-07-05T08:18:05.72+00:00

Hello

Please help me with bellow case.

In my company we have 2 servers (production - name it "A" and data warehouse - name it "B"). On production server we have ERP data. On data warehouse we want to have copy of some tables from ERP tables. We wanted to use sql transactional replication. But when we configured replication on ERP data database we cannot upgrade ERP system.

For now we created sql procedures on server "B" which update tables on "B" based on "A". This procedures are run automaticaly by jobs.

Any better solutions?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,483 questions
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 117.1K Reputation points MVP
    2022-07-05T09:01:44.257+00:00

    There might be better solutions, but then again, if what you have is working for you, that should be good enough, I think.

    As for suggesting other options, we would need to know more about the gory details. There are plenty of ways to skin this cat, but the exact nature of the cat can mean that some ways works better or worse than others.

    As for setting up transactional replication with a third-party system, this is something you need to discuss with the vendor. And if they say no, you should take that as an answer.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.