|
Subject:
|
Migrate Access XP to SQL Server 2000
|
|
Posted By:
|
Walden
|
Post Date:
|
9/19/2003 10:05:38 AM
|
Does anyone knows the procedures as to how to migrate/upgrade Access XP to SQL Server 2000? I look forward to hearing from you.
Regards,
CarlWalden
|
|
Reply By:
|
Bob Bedell
|
Reply Date:
|
9/21/2003 1:54:47 AM
|
You can run the Upsizing Wizard on any .mdb file from Tools->Database Utilites->Upsizing Wizard. All of your tables, indexes, and queries are created on SQL Server, and your forms, reports, modules, and macros are moved to an .adp file connected to your new SQL Server backend. The Access query upsizing is handled variously - they are created on SQl Server as either views, stored procedures, or user-defined function, though a few (like DISTINCTROW queries) aren't upsizeable. The wizard saves a comprehensive snap shot report (.snp) to your My Documents directory of everything it was and wasn't able to accomplish.
HTH
Bob
|
