[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    Re: [PHP-DB] PHP+Linux+MSSQL
From:       snpe <snpe () snpe ! co ! yu>
Date:       2001-06-23 13:31:47
[Download RAW message or body]

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: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net

[prev in list] [next in list] [prev in thread] [next in thread]