Good Oyster
Perch
One of my clients is about to start really building up some data and traffic, and I feel its time to switch from Access to MSSQL. All the apps are in CF, so that is why I posted here - I want to know from a CFMX perspective what to expect.
Are there any differences in SQL that I need to address? What's the best way to transfer data, tables, etc. from Access to MSSQL? What other things should I consider, look for, check, worry about, and otherwise expect?
Would switching to MySQL be a better idea? Pros and Cons, please!
Are there any differences in SQL that I need to address? What's the best way to transfer data, tables, etc. from Access to MSSQL? What other things should I consider, look for, check, worry about, and otherwise expect?
Would switching to MySQL be a better idea? Pros and Cons, please!