How Nasty is it to migrate an Access File to SQLServer

[Ogart]

Greetings:

We've got a quick and dirty CRM solution at beta out there on an Access file. I've just been told by an IT guy who I don't know well enough to trust/distrust that it's not a big deal to migrate and upsize an Access database to MS SQLServer. His recommendation was to keep beta testing and improving the Access utility, and let him know when it's ready to migrate and he can do it pretty easily.

So...

Scale of 1 to 10, how nasty a job is it?
Any caveats?

 

[cmmrfrds]

It should be painless if the naming of the tables and fields do not contain space or special characters. Characters like underscore are okay. There is a upsizing wizard in Access 2000 that I have used to upsize a few mdb files. I have only upsized databases where I programmed the mdb file so I don't know what kind of problems an mdb programmed by an end user could create. Maybe others could weigh in on that.