question

boardtc avatar image
boardtc asked

Does DTS export destination database need to be installed?

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.

mysqldts
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Kristen avatar image
Kristen answered

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?

No, you shouldn't need MySQL installed on the Remote Machine.

On the Remote Machine you just need to make a connection to that Target Machine.

Having said that, making such connections seems to always involve smoke and mirrors :(

You have Source Machine - lets calls that "SRC" - and Destination machine - lets calls that "DST".

On SRC make a connection to MySQL on DST. If its an ODBC connection there are frebie "demo" tools that allow you to make a connection and run a simple SELECT MyColumn FROM MyTable type query.

Once that connection is working you should be able to make a connection direct from DTS - if you used an ODBC connection fro your test that same ODBC connection should be able to be used for the actual transfer

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.