Aqua Data Studio
Aqua Data Studio is fast and danger.
Aqua Data Studio is a ninja.
Aqua Data Studio is a great fucking program, ok?
Aqua Data Studio is a database query tool and administration tool that allows developers to easily create, edit, and execute SQL scripts, as well as browse and visually modify database structures. Aqua Data Studio provides an integrated database environment with a single consistent interface to all major relational databases. This allows the database administrator or developer to tackle multiple tasks simultaneously from one application.
The best part about ADS is the program’s ability to connect to multiple servers in the same window, even if those servers are different RDBMS’s. Last night, I was connected to SQL Server 2000 and mySQL 5.0 at the same time. I used the ADS wizard to export table creation scripts from SQL Server and used a little find/replace magic to make them work in mySQL. Within 5 minutes, I’d moved all the tables over. I’m still working on moving the data. What throws me off is that I need to maintain all of the primary keys, and I’m not sure what voodoo i need to throw at mySQL to make it let me insert values into a field set to auto_increment.