MS SQL Server - Upsize Wizard Error

Author

Upsize Wizard Error

tkosel

2005-04-28, 1:23 pm

I am using WZCS97.EXE to upsize an Access 97 DB to SQL Server 7. I get a
warning.

"Warning! The upsizing wizard has determined that you may exceed the
current SQL Server "locks" setting if you upsize now. "

There is some additional text relative to the current setting as being zero
and the fact that I need 20740 based on the size of my tables. It suggest
that I change the "locks" setting. I cannot find a "locks" setting anywhere
using the enterprise manager. How do I change it?

Also, if I let it go anyhow (Click ok to continue), it runs but tells me it
skipped one table. (The biggest.) However, after it is all done, that table
is there and has the correct number of records in it!!! Can I trust it? Did
it work?

Michael C#

2005-04-28, 8:23 pm

If it's there, it's there. SQL Server has its own locking mechanisms in
place, and the error you got was probably more related to the Access Jet
database engine. As I recall, all Jet has is basically "page-level locking"
which is pretty horrendous if you have more than a couple people using the
database simultaneously. I've run into problems with locking on Jet
before - had to go into the registry to change settings for it; but if it
upsized your data correctly, I wouldn't worry about Jet locking errors since
they don't apply to SQL Server.

Oh yeah, you might want to double-check your schema to ensure that Access
didn't make all your columns (particularly CHAR and VARCHAR) a lot bigger
than they need to be :) Had that happen once or twice as well.

"tkosel" <tkosel@discussions.microsoft.com> wrote in message
news:A973C487-B6BF-4070-94C7- 6AF95819695C@microso
ft.com...
>I am using WZCS97.EXE to upsize an Access 97 DB to SQL Server 7. I get a
> warning.
>
> "Warning! The upsizing wizard has determined that you may exceed the
> current SQL Server "locks" setting if you upsize now. "
>
> There is some additional text relative to the current setting as being
> zero
> and the fact that I need 20740 based on the size of my tables. It suggest
> that I change the "locks" setting. I cannot find a "locks" setting
> anywhere
> using the enterprise manager. How do I change it?
>
> Also, if I let it go anyhow (Click ok to continue), it runs but tells me
> it
> skipped one table. (The biggest.) However, after it is all done, that
> table
> is there and has the correct number of records in it!!! Can I trust it?
> Did
> it work?
>

Sponsored Links