Home All Groups Group Topic Archive Search About
Author
29 Jul 2005 8:02 PM
John
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

Author
29 Jul 2005 8:24 PM
Kevin3NF
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.

--
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


Show quote
"John" <John@nospam.infovis.co.uk> wrote in message
news:ecwWCiHlFHA.3336@tk2msftngp13.phx.gbl...
> 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
>
>
Author
29 Jul 2005 8:44 PM
John
Thanks for that. Any links to guide me with the upgrade process?

Thanks again.

Regards


Show quote
"Kevin3NF" <KHill@NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:eYyhOuHlFHA.3148@TK2MSFTNGP09.phx.gbl...
> 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.
>
> --
> 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
>
>
> "John" <John@nospam.infovis.co.uk> wrote in message
> news:ecwWCiHlFHA.3336@tk2msftngp13.phx.gbl...
>> 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
>>
>>
>
>
Author
30 Jul 2005 1:06 PM
Hari Prasad
Have a look into the below link:-

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

Thanks
Hari
SQL Server MVP

Show quote
"John" <John@nospam.infovis.co.uk> wrote in message
news:OHljO5HlFHA.3300@TK2MSFTNGP15.phx.gbl...
> Thanks for that. Any links to guide me with the upgrade process?
>
> Thanks again.
>
> Regards
>
>
> "Kevin3NF" <KHill@NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:eYyhOuHlFHA.3148@TK2MSFTNGP09.phx.gbl...
>> 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.
>>
>> --
>> 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
>>
>>
>> "John" <John@nospam.infovis.co.uk> wrote in message
>> news:ecwWCiHlFHA.3336@tk2msftngp13.phx.gbl...
>>> 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
>>>
>>>
>>
>>
>
>

AddThis Social Bookmark Button