Support DESK

Follow

S6 - matchIT SQL and Microsoft Azure

Previous Article matchIT SQL Index Next Article 

You may install matchIT SQL on a virtual machine running SQL Server within Microsoft Azure and this is the solution that many clients use, but it's not possible to install matchIT SQL into SQL Azure itself.

Additionally for small databases, it is possible to run a matchIT SQL SSIS package on a local SQL Server machine pointing to a remove 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 SQL Azure database to a local machine and carry out the matching process there before sending results back to the SQL Azure server to be applied to the underlying database.

Previous Article matchIT SQL Index Next Article

 

Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.