Upgrading to SQLServer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 29 Jul 2005 21:02 GMT

Hi

I need to upgrade an access app to sql server, for the first time. In the
first phase I would like to upgrade only the backend to save time. Are there
any pointers for a newbie to help in the upgraded?

I need to give a time/cost estimate to client for the upgrade (backend &
frontend). How does one calculate it for such a work where it is not clear
(at least to me) how much time it will take?

Thanks

Regards

Reply to this Message

Kevin3NF - 29 Jul 2005 21:24 GMT

Make a wild guess on the hours, double it, and add 10%.

No real way to calculate without doing a trial run first. Moving the table
can be fiarly easy, but there will be some Access quirks that won't be seen
right away.

Signature

Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

> Hi
>
[quoted text clipped - 9 lines]
>
> Regards

Reply to this Message

John - 29 Jul 2005 21:44 GMT

Thanks for that. Any links to guide me with the upgrade process?

Thanks again.

Regards

> Make a wild guess on the hours, double it, and add 10%.
>
[quoted text clipped - 15 lines]
>>
>> Regards

Reply to this Message

Hari Prasad - 30 Jul 2005 14:06 GMT

Have a look into the below link:-

http://www.microsoft.com/sql/accessmigration.asp

Thanks
Hari
SQL Server MVP

> Thanks for that. Any links to guide me with the upgrade process?
>
[quoted text clipped - 21 lines]
>>>
>>> Regards

Reply to this Message