It seems that my years of bickering and whining have finally paid off. My office has indicated that they’re interested in moving from our current MS Access website database setup to either MS SQL or MS SQL Express.
I’m trying to anticipate any issues in this change, and one of the things I thought of was the query syntax used on our (CF) web pages. Access requires a fair number of parens when doing joins, and knowing Microsoft, it wouldn’t surprise me if the syntax is different for MS SQL. Since I’ve never used MS SQL before, I have no idea what to expect.
Does anyone here know if there are going to be any page coding changes needed with this switch?
I’m not worried about the databases themselves, because there’s supposedly a conversion tool that works pretty well. I’m more worried about our CF pages breaking. Since we’d be upgrading the development server first, I guess we’ll see what breaks, then fix it before doing the live server.
No, but I can do that. Keep in mind that 99% of our queries just do a SELECT statement because we’re no longer allowed to have pages modify data on the live server. The pages just grab contact info from the database. I’ve gone into the CF admin and restricted all of our databases to only the SELECT clause, and none of the pages broke.
hah! Well when you’re using Access as your database, security is more of a fantasy, so those restrictions are sort of like holding the door shut with a piece of bubble gum.
