Same TableAdapter, Different DB

Question

Hi, having to work in two parallel environments, developement and production, I want to use the same TableAdapter to connect to different databases (two Oracle databases running on different servers) with the very same structure. How is this possible?

Thanks.

Answer 1

Have you tried changing connnectionstring value of your application database connection?

Answer 2

I didn't use TableAdapter before, I always delete them when I create my DataSet. Instead I use DataAdapters.

This might help to change TableAdapter's connection string, but I didn't try it :

Change a database connection string from code