Access™ 2007 Bible

Chapter 41. Upsizing Access Databases to SQL Server

IN THIS CHAPTER

• Understanding the Access ADP data file type

• Working with the Access 2007 Upsizing Wizard

• Upsizing an Access application to SQL Server

• Comparing Access and SQL Server data types

The Access 2007 Upsizing Wizard provides a quick and easy way to upsize Access data to a SQL Server database. Either SQL Server 2005 Express or full SQL Server can be the target of an Access upsizing process. The SQL Server database file is exactly the same, regardless of which edition of SQL Server is used.

Note

SQL Server 2005 Express is a free download from the Microsoft MSDN Web site (http://msdn.microsoft.com/vstudio/express/sql/). SQL Server 2005 Express is a somewhat downsized version of SQL Server Enterprise and contains exactly the same core code as all SQL Server editions. The data file format, Transact-SQL syntax, security architecture, and other specifications are the same in SQL Server 2005 Express and SQL Server 2005 Enterprise. The primary differences between these database engines is that SQL Server 2005 Express does not include several of the more advanced features (such as full text searches) that SQL Server Enterprise includes. Also, SQL Server 2005 Express supports databases up to 4GB in size (SQL Server Enterprise supports terabyte databases). However, SQL Server Express includes SQL Server Management Studio and SQL Server Reporting Services. Furthermore, unlike the Microsoft Database Engine (MSDE) that preceded SQL Server Express, ...