so i can merge them as one.
I heard there is a tool that does this but still to come accross it
any help appreciated.[posted and mailed]
kev (bairdoid@.hotmail.com) writes:
> Is it possible to connect to different databases on different servers
> so i can merge them as one.
> I heard there is a tool that does this but still to come accross it
> any help appreciated.
In MS SQL Server you would set up a linked server and use four-part notation
for your queries:
SELECT * FROM SERVER.db.dbo.tbl
But what MySQL offers, I have no idea. You need to find a forum devoted
to MySQL.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
