SQL To Sql help ....

[David A. Bandel]

On Nov 9, 2007 10:03 AM, Ben Duncan <linux4ms at aim.com> 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.
>
> They are a manufacturer and have a process control machine running winders
> with SQL server (Dont ask why). I have their internal server (Not the
> COBOL accounting machine) which has MySql and some WEB based reports on it.

Basically, what you want to do is replicate from server A to server B.
 This can be done by creating a stored procedure that, after each
successful INSERT, DELETE, or UPDATE runs the identical query against
the remote server.

What you need:  someone to create a stored procedure on the primary
(M$SQL) server.  The reason you might not be able to do this is:
M$SQL bought a decent SQL engine that will do all the things a real
SQL server can (transactions, outer joins, etc.), and MySQL isn't a
real SQL engine, so (last time I looked) hadn't implemented routine
SQL functions like outer joins, etc.

With PostgreSQL to PostgreSQL, the answer would be to use Slony, but
that only works psql to psql.

>
> My question is:
>
> 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 .....;->

AFAIK (which isn't much), the backwards way you want to do this won't
work.  OTOH, who knows what some ingenious fool has contrived.

>
> Thanks ...
>

Ciao,

David A. Bandel
-- 
Focus on the dream, not the competition.
            - Nemesis Air Racing Team motto