APEX SQL

APEX in SQL is a product from Microsoft that is used for synching of data stored on different servers.

We have our main data stored in a main server and replica of those data are stored on different servers.

Consider a scenario of Suvidha or Vishal Mega Mart where the number of stores are distributed all over the country. In this case, every individual store have a database which gets sync with the main database on a daily or an hourly period of time.

If dehradun store sell a product to cutomer that detail needs to be stored on the local server as well as on the main server. For doing that we use the tool APEXSQL which will sync it on the given period of time.

Just install the ApexSql in your system it will sync with your local SQL and performing a series of steps you can also sync it with the remote servers .