Merge between multiple Databases

Asked

Viewed 146 times

0

I have a canteen system that performs sales in different schools. This system only works online, saving the sales movements on the matrix server (MS SQL). To optimize the system, I would like to work with it using a local base, so it would work even without connection and it would be much faster.

The sales terminal has 2GB of memory, and a 40GB SSD hard drive, installed Windows 7.

Now I needed some help picking an option. My first option was to install an instance of MS SQL express and merge the tables, so I would have all the data of the school units, but in this option I am in doubt if the PC will support SQL.

Another option was to install My SQL because it is lighter and try to merge with MS SQL from headquarters.

Would anyone have any tips?

mysql sql-server merge

1 answer

2

Your idea is interesting, but the ideal would be that the local service base attached for reading. Your system must be prepared to read locally and save in the matrix.

In that case I would advise a Transactional matrix replication for your local base. It’s quite simple.

  • 1

    This does not provide an answer to the question. To criticize or ask for clarification from an author, leave a comment below its publication - you can always comment on your own publications and when you have reputation points enough you will be able comment on any publication. - From Review

  • It does not answer directly to the question title, but answers the question itself. At least in my understanding.

Browser other questions tagged mysql sql-server merge

You are not signed in. Login or sign up in order to post.