Whenever I bring programs written at home into the office, I have to change the backend database used by the Datasets. The problem I have is that it takes such a long time, about 3-5 minutes using the Configure command which I assume is because Visual Studio is looking for the home database, and it has to be done for each table in the Dataset. Is there a quicker way of doing it, like changing a connection string somewhere?

I also have to delete and re-created any parameterized queries defined for the tables, but that doesn't take very long though I'd rather not have to do that either.

Thanks for any tips you may have,
David.