Showing posts with label factors. Show all posts
Showing posts with label factors. Show all posts

Sunday, February 19, 2012

Access migration to SQL Server

Hi,
I am deciding which database i should use for my application. One of the
factors that i will use is how easy/difficult it is to migrate from access to
SQL Server / SQL Express Edition.
I'd appreciate any view on this and any links to relevant websites.
Thanks in advance,
MaccaMacca
BOL has pretty good articles about how to create linked server to SQL Server
from Access as well as using DTS Packages to import data from Access.
"Macca" <Macca@.discussions.microsoft.com> wrote in message
news:261D2916-B3B9-4BE9-81C4-47084C12F194@.microsoft.com...
> Hi,
> I am deciding which database i should use for my application. One of the
> factors that i will use is how easy/difficult it is to migrate from access
> to
> SQL Server / SQL Express Edition.
> I'd appreciate any view on this and any links to relevant websites.
> Thanks in advance,
> Macca