On Friday 22 June 2001 15:03, Martin Pavlas wrote:
> Hi all,
>
> I'm totaly lost. I have a Linux server (Debian Potato), which runs
> Apache (1.3.14) + PHP (4.0.5) and MySQL (3.23.39).
>
> Now, I need to connect to other machine (NT) which runs MS SQL 7 and I
> need to insert some data to this machine. I'll read this data from my
> MySQL and I need to store them to the MS SQL. The data will be text
> strings, date, integers, real (not blobs or any binary data).
>
> So, I need to compile PHP to be able to connect to this MS SQL machive.
> But I don't know how to do it.
> Should I do it via native MS SQL functions (and driver) or via ODBC? The
> speed won't be so critical, because the PHP will connect to MS SQL eg.
> every 30 minutes and copy some data from the MySQL. (Well, I need to
> replicate MySQL db to the MSSQL db - so every 30 minutes I'll send there
> only the new records).
>
> - What can you recommend? ODBC or native functions?
> - What is the difference between UnixODBC and iODBC? Which one I should
> use?
> - I found FreeTDS and Sybase drivers. Which one is better and more
> reliable?
>
> The goal is to replicate MySQL to MS SQL (only some tables) and it does
> not matter if it is done via ODBC or native functions, but it must be
> done.
>
> Thanks for your help.
freetds is good (better than odbc)
regards,
peco
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]