Monday, March 26, 2012

Migrating an Access Database to MSDE

I'm very new to MSDE, so this may be a basic question but I've been unable
to find a solution.
Is it possible to migrate a database from Access to a Sqldatabase in MSDE?
If so, how? The Access Upsize Wizard doesn't seem to do it?
Thanks in advance.
The Access upsize wizard should move the data but not much more. You can
also use DTS to import Access/JET database. Unfortunately, an "Access" JET
database also contains, forms, reports, macros and other "stuff" that is
lost when you move to MSDE. The Access application itself also uses
techniques that don't migrate well and don't take advantage of SQL Server's
power.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Tom Wing" <biciwing@.optonline.net> wrote in message
news:c6m7d.22354$kq6.12187878@.news4.srv.hcvlny.cv. net...
> I'm very new to MSDE, so this may be a basic question but I've been unable
> to find a solution.
> Is it possible to migrate a database from Access to a Sqldatabase in MSDE?
> If so, how? The Access Upsize Wizard doesn't seem to do it?
> Thanks in advance.
>
sql

No comments:

Post a Comment