elcabron10 Posted January 17, 2014 Share Posted January 17, 2014 As the topic suggest, is it possible to link two database? (MsSQL and MySQL?) For example if i save something on MsSQL will it be also saved and available to MySQL? Thank You. Quote Link to comment https://forums.phpfreaks.com/topic/285438-mysql-database-linked-to-mssql-how/ Share on other sites More sharing options...
requinix Posted January 17, 2014 Share Posted January 17, 2014 No it will not, and no there is no reasonable way to do that - besides making your code do it manually. Quote Link to comment https://forums.phpfreaks.com/topic/285438-mysql-database-linked-to-mssql-how/#findComment-1465532 Share on other sites More sharing options...
elcabron10 Posted January 17, 2014 Author Share Posted January 17, 2014 Can you point me to the right path where to begin? Quote Link to comment https://forums.phpfreaks.com/topic/285438-mysql-database-linked-to-mssql-how/#findComment-1465534 Share on other sites More sharing options...
requinix Posted January 17, 2014 Share Posted January 17, 2014 Begin doing what? Quote Link to comment https://forums.phpfreaks.com/topic/285438-mysql-database-linked-to-mssql-how/#findComment-1465535 Share on other sites More sharing options...
elcabron10 Posted January 17, 2014 Author Share Posted January 17, 2014 begin doing the connection for php and mssql Quote Link to comment https://forums.phpfreaks.com/topic/285438-mysql-database-linked-to-mssql-how/#findComment-1465541 Share on other sites More sharing options...
requinix Posted January 17, 2014 Share Posted January 17, 2014 Here is a good place to start. Assuming you're using PHP 5.3 or later, first step is getting the SQLSRV extension from Microsoft. Not the mssql extension. Quote Link to comment https://forums.phpfreaks.com/topic/285438-mysql-database-linked-to-mssql-how/#findComment-1465552 Share on other sites More sharing options...
Barand Posted January 17, 2014 Share Posted January 17, 2014 AFAIK regardless of the PHP version, if you want to access a version of SQL SERVER 2005 or later you need the sqlsrv extension as the mssql no longer works Quote Link to comment https://forums.phpfreaks.com/topic/285438-mysql-database-linked-to-mssql-how/#findComment-1465569 Share on other sites More sharing options...
mac_gyver Posted January 17, 2014 Share Posted January 17, 2014 assuming this thread is related to your last one, where you have some application that you could not get to work directly with a mysql database, stringing together your application - ms sql - mysql IS NOT a proper way of getting this to work. you will end up with a solution that will be difficult to manage and maintain, with data that gets out of sync easily, and if this is for a real company that is expected to make money, could get you fired for even suggesting it, or if for a government project, will get you promoted. Quote Link to comment https://forums.phpfreaks.com/topic/285438-mysql-database-linked-to-mssql-how/#findComment-1465570 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.