Jump to content


Photo

ODBC driver


  • Please log in to reply
1 reply to this topic

#1 cK

cK
  • Members
  • PipPip
  • Member
  • 11 posts

Posted 05 June 2003 - 08:53 PM

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

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 06 June 2003 - 04:21 AM

Try this

http://www.phpfreaks...orials/61/0.php
http://php.weblogs.com/odbc
http://cs1.mcm.edu/t.../php-odbc.phtml
http://www.databasej...cle.php/1491011

U can find lot more....
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users