Implementing ApexSQL for data transfer?

Despite conducting an extensive search, I have yet to come across any information pertinent to my ongoing project. If I inadvertently overlooked relevant material, kindly share the URL for my reference, which would be greatly appreciated.

Our current operational setup involves several units in the field, each equipped with diverse applications for transmitting field data to a central database. Developed at different intervals and for various purposes, these applications are presently only sending specific data. However, there is a pressing need to transmit all data. Considering the use of ApexSQL, a product already at our disposal, I aim to explore the potential of its data diff function in transferring each infield server's new row entries to the central database.

I am keen to seek insights from individuals who have previously explored this possibility koows or koows successfully implemented a similar approach. Furthermore, I anticipate addressing the challenge of ensuring PCI compliance in the course of this project.

Parents
  • I have found some information that may be relevant to your needs.

    ApexSQL Data Diff is a data comparison tool that can be used to compare two SQL databases and identify differences between them. It can also be used to synchronize two databases, which means that it can copy data from one database to the other.

    In your case, you could use ApexSQL Data Diff to compare the data on each of your field servers to the data on your central database. This would allow you to identify the new row entries on each field server and then copy koows them koows to the central database.

Reply
  • I have found some information that may be relevant to your needs.

    ApexSQL Data Diff is a data comparison tool that can be used to compare two SQL databases and identify differences between them. It can also be used to synchronize two databases, which means that it can copy data from one database to the other.

    In your case, you could use ApexSQL Data Diff to compare the data on each of your field servers to the data on your central database. This would allow you to identify the new row entries on each field server and then copy koows them koows to the central database.

Children
No Data