Skip Navigation LinksHome > UpsizingPRO > SSW Upsizing PRO! - Access to SQL Server Upsizing Utility

SSW Product

There was an error displaying the testimonials. Please report this error to SSW and include the following text:
- A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

 
Tuscows review
starstarstarstar
Shareware River
starstarstarstarstar

Access to SQL Server Upsizing Links

Builder.com You are about to leave the SSW site
Upsizing an existing Microsoft Access Database

Microsoft Knowledge Base Article-237980 You are about to leave the SSW site
INF: How to Convert an Access Database to SQL Server

What will not be upsized
SSW Rules to Better Access Databases

Upsizing - Data Type mapping
A comparison of data types in Access and SQL Server

Upsizing - Data Transformation Services (DTS) You are about to leave the SSW site
How to Use DTS to Export Data from a Microsoft Access Database to a SQL Server Database

Upsizing - Tales From the Battlefield
A comparison of DTS and the Upsizing Wizard, and several hints and tips.

DTS Problems
A developers account of his DTS Horror Story

DTS Data Migration
DTS Data Conversion and Transformation Considerations

Relationships in Access and SQL Server
Are they the same?

SQL Server Object Naming Standard
SSW's Standard for naming SQL Server Objects.

SQL Server Stored Procedure Naming Standard
SSW's Standard for naming Stored Procedures.

SQL Server Stored Procedure Formatting Standard
SSW's Standard for formatting Stored Procedures

SQL Server Indexes Naming Standard
SSW's Standard for naming Indexes.

SQL Server Relationship Naming Standard
SSW's Standard for naming Relationships

Database Design Standards
SSW's Standards for designing Databases in SQL and Access.

Microsoft Knowledge Base Article-176614 You are about to leave the SSW site
ACC97: Microsoft Access 97 Upsizing Tools Available

Access 97 Upsizing Wizard You are about to leave the SSW site
Free download available from Microsoft. (Upsizing Wizard included in Access 2000/2002)

Microsoft Knowledge Base Article-279454 You are about to leave the SSW site
ACC97: "Overflow" Error Message When You Try to Upsize to SQL Server 2000

Using the Microsoft Access 2000 Upsizing Tools with SQL Server 7.0 or MSDEYou are about to leave the SSW site
A walkthrough of the process of Upsizing with the Wizard - outlining many of the pitfalls that Upsizing PRO! will prevent for you - automatically. Summary KB You are about to leave the SSW site

Upsize Your Database: Convert Your Microsoft Access Application to Take Advantage of SQL Server 7.0. You are about to leave the SSW site
Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use.

Microsoft Migration White Papers (MS Word)
1. Whats New And Different When Moving Your Backend To SQL Server
2. How To Migrate From Access To SQL Server

Information on how to migrate tables and queries into SQL Server scripts, views, and stored procedures, and methods to ensure that applications, once in place, are tuned to run efficiently

ODBC/OLE DB Database Migration You are about to leave the SSW site
Migrating from ODBC and OLE DB databases to Microsoft SQL Server 7.0.

How to Convert an Access Database to SQL Server You are about to leave the SSW site
How to convert an Access database to SQL Server using the Upsizing Wizard.

Recommended Methods for Upsizing You are about to leave the SSW site
Read about Upsizing PRO! being recommended by the authoritive SQL Server FAQ by Niel Pike.

MSDE - The Missing Piece You are about to leave the SSW site
Read about MSDE and how it fills a long-awaited void in the database architect's toolkit.

Jet Table Constraint Silently Fails to Upsize You are about to leave the SSW site
Field level validation does upsize, but I Table level validation rules fail to upsize

Incompatibility issues between Access 2000 Projects and SQL Server 2000 You are about to leave the SSW site
Read about the incompatibility problems faced between ADP's and SQL Server 2000

Administrative Update Available for Access 2000 and SQL Server 2000 Readiness You are about to leave the SSW site
Read about A tool that will help you deploy the Access 2000 and SQL Server 2000 Readiness Update.

Optimizing Client/Server PerformanceYou are about to leave the SSW site
Read about techniques you can use to improve the performance of client/server applications.

What utilities and updates should I get for my PC?
This is one of the frequently asked questions by SSW clients, so we have compiled a list.

Access 2000 Upsizing Tools The Access 2000 Upsizing Tools white paper (Upsize00.doc) describes how to use the improved Upsizing Tools included in Access 2000. Use the document as an aid in preparing to migrate the data in an Access 2000 database to SQL Server or the Microsoft Data Engine (MSDE), creating a client/server application from an Access 2000 database, and troubleshooting errors in the upsizing process itself.

Access 2002 (XP) Upsizing ToolsYou are about to leave the SSW site
The Access 2002 Upsizing Tools white paper (Upsize02.doc) describes how to use the Upsizing Tools included in Access 2002. Use the document as an aid in preparing to migrate the data in an Access 2002 database to SQL Server, creating a client/server application from an Access 2002 database, and troubleshooting errors in the upsizing process itself.

Access 2002 (XP) Upsizing Tools Update: March 23, 2004 You are about to leave the SSW site
Microsoft has released an update to Microsoft Access 2002. This update fixes an issue where descending indexes in Access 2002 that have been upsized to SQL Server may still be upsized as ascending indexes after you install Microsoft Office XP Service Pack 3. This update makes sure that Access 2002 wizard files are updated correctly.

What do I need to know about the differences between Access and SQL Server? You are about to leave the SSW site
This is one of the frequently asked questions by SSW clients.

Why and when should I upgrade/upsize to SQL Server?
How many users? How many connections? How big should my Access database be before I upgrade?

What is the best way to program a stored procedure?
SSW standards? Naming conventions? Coding rules?

Do you want to know more about upsizing?
SSW knowledge base on upsizing

Microsoft SQL Server Performance Tuning You are about to leave the SSW site
Learn how to best configure your installation to gain maximum performance from Microsoft SQL Server 2000 with this collection of tuning guides and white papers.

Top 10 Performance Tuning Steps You are about to leave the SSW site
These are the top 10 performance tuning steps sorted by order of greatest effect on overall database performance. These steps are database independent and so can be applied to any system you are tuning.

SQL Server Performance Tuning - Part 2 (Subsystems, part 1) You are about to leave the SSW site
There are many subsystems that make up a typical server. It is very important that you understand the different systems that make up a server and some of the potential bottlenecks that lie within.

Microsoft Access and SQL Integration Resources You are about to leave the SSW site
There is a wide variety of Microsoft Access and SQL Server integration resources.

SQL Server Script samples You are about to leave the SSW site
There is a wide variety of SQL script samples.

Microsoft Knowledge Base Article-287484 You are about to leave the SSW site
OFF2000: Administrative Update Available for Access 2000 and SQL Server 2000 Readiness

Microsoft Knowledge Base Article-288300 You are about to leave the SSW site
"Microsoft Access Can't Find the Wizard..." Error Message

SQL Server Migration Assistant for Access (SSMA Access) You are about to leave the SSW site
Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from Microsoft Access versions 97 through 2003 to Microsoft SQL Server 2005. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server.
However, SSW tested SSMA on "1 SampleData2000 - Examples of Upsizing Issues.mdb" provided in %Program Files%\SSW Upsizing PRO\Samples folder. One table gone missing in SQL Server 2005 and in a few tables records were not upsized.
Upsizing by SSMA - SSW Upsizing PRO! report

Access Links