I need to move an SQL Server 2000 database to MySQL. I'm running into several complications. I'm no expert on SQL Server. To get going I'd like to have a csv-dump of structure and data.
First issue, 3 tables which are clearly in use by the application are not listed in the Tables view. When generating a diagram, a popup appears stating that those tables couldn't be loaded. The weird thing is that data from those tables is actually returned in the application (not cache).
The second issue is the use of DTS. I'm using the wizard to export the DB to text. I'm selecting "Copy table(s) and view(s) from the source database". Then, I get to choose the file type, delimiters etc. There's a drop-down which has the first table selected. My problem is, I can only select 1 table but I need to export the entire DB. When continuing, the server will only export the first table. How do I get it to export the entire DB? Doing it table by table will take far too much time.