cK Posted June 5, 2003 Share Posted June 5, 2003 Hi, Due to security reasons and the fact our website is running php/mysql we want to export tables from our MSSQL server at our office to our MqSQL server at our hosting company. I heard this can be done with an ODBC driver. I only don’t know how this works exactly and couldn’t google-up an tutorial. Who can help me?! Next to this I\'m wondering if you can give a \"where statement/search routine\" on every table before exporting. This due to fact our MSSQL database is very larger and not all data is needed online. For example: only records with status \"active\" or \"changed last 15 days\" or only \"id,name,company,...,....,....,.....,....\" and so on... Thanks in advance, cK Quote Link to comment Share on other sites More sharing options...
shivabharat Posted June 6, 2003 Share Posted June 6, 2003 Try this http://www.phpfreaks.com/tutorials/61/0.php http://php.weblogs.com/odbc http://cs1.mcm.edu/tutorial/htmlguid/php/p.../php-odbc.phtml http://www.databasejournal.com/features/ms...cle.php/1491011 U can find lot more.... Quote Link to comment 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.