Upsizing a Access database

  • Thread starter Thread starter Petter L
  • Start date Start date
P

Petter L

I trying to upsize a access 2000 database to sqlserver but the conversion
process just stop after it has started. The end report saying all tabels
have been skipped. I'm new to this area, is there something I missing ?

Petter L.
 
There's a lot of things that can go wrong because Access and SQL
Server have a lot of incompatibilities in the area of datetime ranges,
data types, and validation rules. If the wizard barfs on one of these,
it can decide to just skip the table. See "How to Convert an Access
Database to SQL Server" (it has links to several papers)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q237980

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Sun, 28 Mar 2004 17:50:59 +0200, "Petter L" <petter at
 
I have looked must of it trough but many issues is on Access 2000 without
sp1. I have the latest patches installed. The file is an empty database only
tables and queries. I have even tried Access XP and it gave me the same
result.

Petter L.
 
Nobody but you can figure out what's wrong with the tables (data type
conversion, values out of range, validation rules, etc) except you.
Another option is to skip the upsizing wizard and use DTS. The best
way to do that is to create the schema in SQL Server, and just load
the data.

--Mary

On Tue, 30 Mar 2004 00:05:04 +0200, "Petter L" <petter at
 
Back
Top