I'm starting to think this may be the impossible dream, but does anyone have ideas for import / export of upwards if a half million rows using the standard DNN import / export methodology?

My assummption at this point is the overhead of having to return a string that XML is encoded is going to make that prohibitive. I am considering an option of using short attributes in the serialization process, but maybe have to revert to a standalone comma delimited variation just for the high volume tables.

SSIS isn't really an option in many cases. Works fine for local migrations between environemtns but it doesn't work well when I need to migrate from a hosted environment to a local one and back. I can't do a push to a SQL express on a workstaion using SSIS and the process is really not freindly enough for the developers to do repeatidly. I need to be able to take a database, and populate the schema, deploy the GUI, the load the database in a process that has as few steps as possible. A dnn module installation followed by a Import would populate a fresh image that I will need on multiple machines in remote locations.

In any case I know lots of ways to do it outside of DNN. My question really is has anyone done large volume import / export with the DNN framework, and if so, how.

 I like that approach, but the destinations in question are 9 time zones away and I have no idea when they'll be up. Now having a process they fire off that calls a web services on this end to repopulate would be nice, and I may consider that option for some other projects.