from Access to SQL server

[marc p]

I wonder who could help me with this.

Is it possible to migrate an already programmed database
in MS Access to SQL Server or this needs complete
reprogramming?

Thank you

marcp

 

[John Nurick]

Hi Marc,

This depends largely on (a) your database and (b) whether you want to
benefit from the increased performance that SQL server can deliver. With
a simple database and no need to optimise performance, you may need to
do little more than run the Upsizing Wizard. On the other hand, if you
are moving to SQL Server in order to provide better support for large
numbers of users, major revision is likely to be needed in order to
transfer processing from the Access client to SQL Server.

For more information about upsizing, see the relevant white papers:
Access 97: http://support.microsoft.com/?id=175619
Access 2000: http://support.microsoft.com/?id=241743
Access 2002: http://support.microsoft.com/?id=294407

I wonder who could help me with this.

Is it possible to migrate an already programmed database
in MS Access to SQL Server or this needs complete
reprogramming?

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 

[Tony Toews]

Is it possible to migrate an already programmed database
in MS Access to SQL Server or this needs complete
reprogramming?

You can migrate your existing MDB. Although it may be a lot of work.

Do a search at the Knowledge Base at support.microsoft.com using the
keywords "upsizing" to review the various white papers on upsizing
Access to SQL Server as well as to ensure you have any updates
required.

Also see my Random Thoughts on SQL Server Upsizing from Microsoft
Access Tips page at my website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm