sql - Database tool for inter-db joins -

sql - Database tool for inter-db joins -

can suggest database tool? i'm doing enterprise integration, selecting both sql server , mysql dbs. i'd bring together tables in sql server tables in mysql comparing , testing. portable if possible, don't have admin on machines i'm running on. thanks,

not sure mysql side of things can ssis (sql 2005+) or dts (earlier sql 2005) long have drivers connect both instances. can write bundle bring in datasets both servers , store results wherever (db, flat files, etc).

you write powershell script query instances (assuming have drivers/clients both sql server , mysql installed on machine).

sql sql-server database