SQL To Sql help ....

[James McDonald]

Ben Duncan wrote:
> As a newbie to SQL, I have picked up a project from one of my clients 
> and need
> to figure out if it an be done.
>
> Is it POSSIBLE to have the MySql PULL that tables over from the SQL 
> Server
> machine every night and update it's tables? How is it done? What do I 
> need
> to do .... Inquiring minds want to know .....;->
>
>
If you have php installed I think it has an interface to the freeTDS 
libraries http://www.freetds.org/ that interface with SQL server.

I have only gotten as far as logging on to SQL server with the tsql 
command line utility. From the horses mouth....

"It supports many different flavors of the protocol and three APIs to 
access it. Additionally FreeTDS works with other software such as Perl 
and PHP, providing access from those languages as well."

Also you could just dump data from the SQL box to file and then pick it 
up, format and insert. But a direct connection to the SQL box would be 
neater.