>My question is how can I globally change each tableadapter to point to a specific connection string?
>
>For example, I might want to switch from PROD to the DEV database connection string. I might have 20 tableadapters, changing each one using the property sheet is not desirable.
>
>Isn't there a global way to do this?

Well, now I understand what you are trying to do.
If you want to switch between different databases, the connectionstring itself is the place for that.
Your tableadapters should always point to the same connectionstring definition of your app.config.
To switch to a different database, just change the connectionstring in your app.config.