April 27, 2009 at 9:20 am
i have imported the backend of an Access database into SQL express 2008 and relinked the front end to the server. the author of the database has looked it over and did not see anything that would ill affect the db's operation. What else should i take into consideration before i put this into a production environment?
April 27, 2009 at 9:48 am
Please forgive me if this is too elementary, I just don't want to make any assumptions about what you would do as a matter of course.
1. Regression test against the original for accuracy and performance
2. Develop a backup plan and a maintenance plan for the database and determine who will check the backup status
3. Set up the appropriate database security
4. If the person who will be running the express instance has little or no SQL Server experience, put together procedures for starting and stopping the server and other related services
5. If the express server is running under an account whose password may change, write a procedure for changing the password on the appropriate SQL Server services
That should at least get you started.
April 27, 2009 at 10:43 am
is there anything i should do to the access client to help streamline operation with the SQL server?
April 27, 2009 at 10:51 am
What do you mean by streamling? Is this performance or process based?
April 27, 2009 at 10:51 am
Sorry, I don't know enough about Access itself to help with that.
I do know that some adddtional tuning of queries and indexes may be necessary if performance is not as expected. Access and SQL Server may make different decisions about how to attack query resolution and performance characteristics may change because of that. A good regression test should surface those issues.
April 27, 2009 at 10:57 am
what is a regression test and how do i go about conducting one?
April 27, 2009 at 11:00 am
A regression test is a retest of your code. So you set up tests to determine if it is functioning properly.
As you make changes, add new modules, etc., you should have those tests scripted and re-run them against the application to be sure that it still works. That's a regression test.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply