Hi, my website is starting to grow so I would need to convert my database from Access to SQL. I'm going to outsource this work and I was just wondering how much work is required? I have about 3,500 registered users...the database consists of names, passwords, emails, etc etc. Is this job do-able within a few hours of work? Or is this job going to cost me $500+ to do?
I would guess with the right tools and experience $200 or less. The actual data conversion should be real quick but you are paying for the tools and experience. You may have other issues than the conversion if you are using scripts to interact with that DB. How is that data used?
You're right. My website uses the db data to retrieve user information ...ie: pictures, profile, etc. I guess there is more work to be done to the scripts.
you might get lucky and only have to change the connectionstring in the scripts. autonumbers and memo field in access are sometimes challenging to convert. There is a good thread for the forum migration: http://www.webwizguide.info/bbs/forum_posts.asp?TID=12975 good luck!
I converted a forum from access to the mysql in the past, so if you still need this, I can give you a quote based on the scripting language you use.
database conversion might be easy.. but script conversion or a complete rewrite (depending on platform asp,php,asp.net) is challenging