Product Description
Microsoft SQL Server and MySQL servers both have their advantages and disadvantages in a production environment. Often a business will have a Microsoft SQL Server environment in their back office infrastructure and a MySQL based web platform. Getting both to talk to each other is awkward and although partly being solved over time with increasingly flexible import/export methods, it would be so much easier SQL Server could simply talk directly to MySQL Server. It can and this guide will show you a working example of exactly how.
This PDF guide will demonstrate how to:
Add and correctly configure a MySQL server as a linked server within Microsoft SQL Server Management Studio.
Professionals may be able to get a MySQL linked server to SELECT data, but not any other transactions. This guide will demonstrate SELECT, DELETE, INSERT and UPDATE SQL statements (including JOIN) to fully interact with your MySQL server.
This PDF guide will also avoid the following common errors:
“Commands out of sync; you can’t run this command now”
"Insufficient key column information for updating or refreshing"
This PDF guide will demonstrate how to:
Add and correctly configure a MySQL server as a linked server within Microsoft SQL Server Management Studio.
Professionals may be able to get a MySQL linked server to SELECT data, but not any other transactions. This guide will demonstrate SELECT, DELETE, INSERT and UPDATE SQL statements (including JOIN) to fully interact with your MySQL server.
This PDF guide will also avoid the following common errors:
“Commands out of sync; you can’t run this command now”
"Insufficient key column information for updating or refreshing"
