re: Cross-Version Database Attachments, DBCC UPDATEUSAGE, and UPDATE STATISTICS

Kyle Schoonover — Fri, 24 Oct 2008 21:12:34 GMT

Ward, I'm currently working in MySQL and writing conversion scripts to convert a MySQL database to a SQL 2005 database. I have also been using OpenQuery to query through a linked sterver from SQL 2005 to MySQL. I was wondering if you could comment on a way to possibly use DTS to transfer data from a database that is not readily supported like MySQL.

Also is there something better than using OpenQuery to create dynamic SQL to run against a linked server database that runs on MySQL.

Also, I hope you are liking Florida. I hope to catch you for lunch sometime with Carl if you make it back here.

Cross-Database Connectivity: An Answer For Kyle

Ward Pond's SQL Server blog — Sat, 08 Nov 2008 06:30:13 GMT

Kyle Schoonover, a former colleague in MSIT, posed the following questions in a comment on October’s