I began building a DNN site for my company on my own server at home, in anticipation of launching the company's new Web server.

I am running SQL 2k5.

They have SQL 2k.

Oops.

Is there a migration tool available? If, not then

I am looking at exporting/importing the data as it is my understanding that the disk read process is different.

As if, that wasn't enough, I am obviously moving the whole install to a brand new server/domain. Sounds fun huh?

If this is the case & I have to export/import then I was wondering if anybody has experienced this issue and if so, how successful was the transition? Considering that I have only put together the infrastructure and the content is ... light, would I be better off just going with a new install?

As always, thanks in advance!

Sigh. Figures.

Well, live and learn. Won't do that again.

I don't know how much content you have, but it should not be too difficult to migrate the data since the table structure is exactly the same.  Before giving up I would look at a tool like Red-Gate SQL Compare and Data Compare or the APEX SQL Suite.  Both of these tools should be able to connect to both a SQL 2005 and SQL 2000 db and do the migration (assuming you are not using any modules with SQL 2005 specific code).