Upsizing 2k3 mdb to SQL Server 2000

[Dale Fye]

I've only done this a couple of times, and never encountered any problems.
But today, when I tried to upsize a simple (5 tables) mdb to SQL Server 2000,
all I get from the Wizard Report is:

Table: tbl_Arcs
Table was skipped or export failed.

I got the same message for all 5 tables. Did this a couple of times with
different settings. Most recently, I chose to export Indexes, but not table
relationships.

Any ideas?

 

[Tom van Stiphout]

On Fri, 7 Mar 2008 05:40:06 -0800, Dale Fye <[email protected]>
wrote:

You don't provide enough information.
Fortunately it's a small db, so you can do it manually.
If you like, you can run SQL Server Profiler when you upsize; you may
see an offending instruction. Perhaps an object name too long, or
containing illegal characters.

-Tom.

 

[Dale Fye]

Tom,

I'm relatively new to the SQL Profiler, and didn't realize the profiler
would allow me to do that, pretty cool.

I had tried to do it from the reverse direction (using DTS) but the datatype
conversion caused some problems with my application, so I deleted the
database from SQL SERVER and tried the upsizer again. Don't know what I did
differently, but with the profiler on, it worked.

Thanks for the tidbit on the Profiler.


--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.