This organization has data in various places including MySQL 5 databases and SQLServer 2000 (developer edition) on Win2k Server. For the data in MySQL I have used PHPMyAdmin, mysqldump, and so on to get data out and transform it. I've also written some simple Ruby Rails code to work with the MySQL data and used SQLYog (pro) to transfer data from SQLServer 2000 to MySQL 5. Now I need to get some data from the SQL Server 2000 databases and I'd like to do it without having to write code (or make changes to legacy ColdFusion app's codebase). This doesn't seem unreasonable ...
SQL Server's Query Analyzer can probably save query output somehow. I'm pretty sure I could use the SQL Server console as well and pipe that into a file in a console and then do transforms on that. What's a better tool? Is there a tool like PHPMyAdmin for SQLServer 2000 or some other quick way to get CSV from SQLServer 2000 with little or no code?