View Single Post
  #2 (permalink)  
Old September 21st, 2003, 01:54 AM
Bob Bedell Bob Bedell is offline
Friend of Wrox
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts

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.



Reply With Quote