I am trying to get data from a remote machine which has sql server 2000. I do not have sql server myself. I tried exporting to excel, but hit they 65,535 row limit as was kindly explained to me on this site. I tried installing the free sql server express 2005 but was not able to get it to read the dts exported sqlserver file.
I am now looking at exporting to mysql. I was able to install the mysql connector odbc driver on the remote machine which gives me the option to select mysql in my dts export. The problem I now have is that when I select the mysql (or indeed any) odbc one needs to have a DNS. My understanding now is that to create a DNS I would need to have MySql installed on the remote machine? If this right, is there anyway to export to MySQl format without having MySql installed?
If this is the case then I am back at the drawing board in figuring out how to get this data out in a database format which I can use - I need to be able to analyse the data and run sql queries.