Easy to switch backend to SQL?

[Guest]

I have an access 2000 database. And a SQL 2000 server. Is it easy to move
all the data and switch over everything to the sql server? I will keep using
the access front end. What are some problems that might or most likely
arise?

 

[Kevin3NF]

Bit fields need a value for each record and a default value for the field

Upsizing wizard may or may not pick up the relationships, indexes, PKs, etc.

Importing or upsizing sometimes doesn't get non pk not-null fields and keep
the "not-null" part

When you re-link the tables after editing one, it comes in as dbo.MyTable
instead og MyTable (or whatever the owner is....)

I prefer to do this with a DTS import on the SQL Server side.

Its not horrible, but it's not a 10 minute process

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions