Best Test environment

[barbarao]

Hi. Have an ACCESS front end and SQL Server back end. Need to start redesigning the back end but folks still need to be using the DB. What is my best bet for a test environment? I was thinking SQL Server Developer Edition. Throughts would be appreciated. Thanks.

[r035198x]

Depends on how much SQL Server specific stuff you are going to use and what kind of testing strategies you are employing. In-memory databases are preferred for unit tests but if you are setting up an integration testing environment then you want to use the one as close to the production one as possible.

[barbarao]

Depends on how much SQL Server specific stuff you are going to use and what kind of testing strategies you are employing. In-memory databases are preferred for unit tests but if you are setting up an integration testing environment then you want to use the one as close to the production one as possible.

I'll be merging tables, creating new tables, and revising all the routines to accomodate the new structure. Please trying to build new automation features. I've never done something like this with a SQL backend.