I was really excited today when a colleague gave me a lead on what I had hoped might become my first production Rails site. Almost as quickly, my joy began to fade upon speaking to the client. He wants a storefront that integrates with his existing POS database...a product called CamCommerce. A bit of research on this software (I''d not heard of it) suggests that the database backend that CamCommerce uses is some sort of proprietary system that is particularly fragile, and might be best avoided. Does anyone have any familarity with migrating data from this system to MySql? Considering this customer is already heavily invested in his POS software, and not likely to want to change to something better, is this worthwhile to take on as a 1st project, or should I perhaps pass on this and wait for another opportunity? Thanks for any input about CamCommerce (Cam32, Star Retail), Dean
does this database have the ability to be dumped ? anythign that can be dumped and readable, can almost certainly be converted into mysql importable format. adam H. Dean Roberts wrote:> I was really excited today when a colleague gave me a lead on what I had > hoped might become my first production Rails site. Almost as quickly, my > joy began to fade upon speaking to the client. He wants a storefront > that integrates with his existing POS database...a product called > CamCommerce. > > A bit of research on this software (I''d not heard of it) suggests that > the database backend that CamCommerce uses is some sort of proprietary > system that is particularly fragile, and might be best avoided. > > Does anyone have any familarity with migrating data from this system to > MySql? Considering this customer is already heavily invested in his POS > software, and not likely to want to change to something better, is this > worthwhile to take on as a 1st project, or should I perhaps pass on this > and wait for another opportunity? > > Thanks for any input about CamCommerce (Cam32, Star Retail), > > Dean > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails
>Does anyone have any familarity with migrating data from this system to >MySql? Considering this customer is already heavily invested in his POS >software, and not likely to want to change to something better, is this >worthwhile to take on as a 1st project, or should I perhaps pass on this >and wait for another opportunity? > >Thanks for any input about CamCommerce (Cam32, Star Retail), > >Dean > >A quick search on their product page found this: "access the data in the database through third-party programs using ODBC tools and standards" Which means you should be able to dump the database over to MySql. Whether or not you should take it as your first project is up to your confidence level in completing the project. HTH, Vanessa