4 replies
by cat873
by howardro
If you're looking to convert an Access Application to a SQL Server backend then you have to ensure that you're queries and objects are ANSI-92 compliant. This company, Expert Database Solutions, has released a nifty tool that generates a report of queries and objects that require modification and what needs to be changed. Well, I think it's worth a download.
http://www.expertdatabasesolutions.com/Downloads.htm
by seanc
Cat,
I think what you are asking for is a very prudent step and I think your boss will appreciate your caution. It is one thing to upsize your data, it is another to insure that your SQL server is configured correctly to make sure you have continued smooth operations with your billing systems.
Simply put a memo together to your boss (I believe in writing things like this down so you can come back to it later to prove you asked) and tell him/her that while you have made the pre-liminary steps to improve your billing operations by moving the back end to SQL Server, you think it would be wise to have some expert help to look over your plan, validate your SQL Server setup, and help you with the move to production. Explain that by not doing so, the company runs the risk of potentially having their billing operations interrupted, thus causing lost time and money. Get a quote for an hourly and daily rate from some local companies that have SQL server consultants on staff then prepare a best case worst case estimate. Given the information you have provided, my guess is that your best case would be 2 to 3 days of work and worst case is 7 days provided you have a qualified consultant. I assume the consultant would look at your server, verify that it (SQL Server) is installed properly, is patched correctly, is tuned accordingly and have the proper security and other parameters set and can handle the proposed load. Once that is done, they would then work with you on your migration scenario. All very doable in a couple of days.
Hope this helps!
Ramon
This discussion is closed to new replies.
Trending IT Employment posts
Sort by Trending