Previous Article | matchIT SQL Index | Next Article |
You may install matchIT SQL on a dedicated virtual machine running SQL Server within your cloud environment and this is the solution that many clients use, but it's not possible to install matchIT SQL into a cloud based database such as SQL Azure.
Additionally for small databases, it is possible to run a matchIT SQL SSIS package on a local SQL Server machine pointing to a remote SQL Azure database, however it may be slow and you could experience timeouts. SQL Azure is not really built for large data queries as used within data duplication processing.
Matching is a resource intensive process so wherever possible we recommend running on a dedicated local server. One option is to pull a copy of your cloud based database to a local machine and carry out the matching process there before sending results back to the cloud database server to be applied to the underlying database.
Previous Article | matchIT SQL Index | Next Article |