Probably having a linked server to MySQL is better one
EXEC('CALL ClientSelectExtract
(''2009-10-07'',''2009-10-07'');') AT MySQLSERVER;
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
No comments:
Post a Comment