Add the ability to swap the connection to one database with a different connection without needing to remove all the tables/views, etc and add them all back. I'm explicitly referring to a SQL server datasource. It is very difficult (and redundant) to maintain/enhance an application used for testing (connected to test database) AND an application for production (connected to production database). There should be a way to easily redirect the application to the test database then when ready switch it back to the production database.
If this ability already exists, please let me know! Thanks.