p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Migrate Access XP to SQL Server 2000 (http://p2p.wrox.com/showthread.php?t=4057)

Walden September 19th, 2003 10:05 AM

Migrate Access XP to SQL Server 2000
 
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

Bob Bedell September 21st, 2003 01:54 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



All times are GMT -4. The time now is 08:48 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.