Replace the legacy solution of data exchange between database servers through Service Broker, as well as propose a new architecture to be the new solution. Review all SQL Server database servers proposing how to improve their performance and availability.
The legacy environment between data exchange was analyzed, as well as the solution that currently existed of Service Broker. A new solution was proposed using an existing tool not yet used. After the release of the accesses to all Production and Quality servers, tuning adjustments were proposed to the customer.
Use of SQL Server Integration Services – SSIS with the proposal of a new data exchange structure through queues. Integration between the new portal and the legacy system through SSIS for creation of customers, payment orders, creation of cards and replacement. Tuning in all Sql Server database servers.
