Testimonials
 |
SSW Upsizing PRO! pays for itself many times over in the first hour of use. If you need to upsize an Access database that has seen any real use, don't start without this great tool. |
 |
-
Sanjay Singh, Smart Access and Access VB SQL Advisor
Access to SQL Server Upsizing Links
Builder.com
Upsizing an existing Microsoft Access Database
Microsoft Knowledge Base Article-237980
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)
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
ACC97: Microsoft Access 97 Upsizing Tools Available
Access
97 Upsizing Wizard
Free download available from Microsoft. (Upsizing Wizard included in Access
2000/2002)
Microsoft Knowledge Base Article-279454
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 MSDE
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
Upsize
Your Database: Convert Your Microsoft Access Application to Take Advantage of SQL Server 7.0.
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
Migrating from ODBC and OLE DB databases to Microsoft SQL Server 7.0.
How to Convert
an Access Database to SQL Server
How to convert an Access database to SQL Server using the Upsizing Wizard.
Recommended
Methods for Upsizing
Read about Upsizing PRO! being recommended by the authoritive SQL Server FAQ
by Niel Pike.
MSDE - The Missing
Piece
Read about MSDE and how it fills a long-awaited void in the database architect's
toolkit.
Jet Table
Constraint Silently Fails to Upsize
Field level validation does upsize, but I Table level validation rules fail
to upsize
Incompatibility
issues between Access 2000 Projects and SQL Server 2000
Read about the incompatibility problems faced between ADP's and SQL Server 2000
Administrative
Update Available for Access 2000 and SQL Server 2000 Readiness
Read about A tool that will help you deploy the Access 2000 and SQL Server 2000
Readiness Update.
Optimizing
Client/Server Performance
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 Tools
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
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?
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
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
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)
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
There is a wide variety of Microsoft Access and SQL Server integration resources.
SQL Server Script samples
There is a wide variety of SQL script samples.
Microsoft Knowledge Base Article-287484
OFF2000: Administrative Update Available for Access 2000 and SQL Server 2000 Readiness
Microsoft Knowledge Base Article-288300
"Microsoft Access Can't Find the Wizard..." Error Message
SQL Server Migration Assistant for Access (SSMA Access)
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