Dave Guyer wrote: > > Are data types the same in MySQL, PostgreSQL and SAP DB?
There are same datatypes and there are different datatypes. > If not, what are the differences? for example: MySQL has NUMBER-datatypes with option like UNSIGNED/ZEROFILL, TINYINT/MEDIUMINT or the like which are similar with FIXED/FLOAT + some constraint in SAP DB. MySQL has TINYLOB/TINYTEXT/... which are similar to LONG in SAP DB and so on and so on. > What problems will we run into migrating from MySQL to SAP DB? That depends on your application, which features, datatypes, functions, side effects (not throwing errors even if they could be expected) your application relies on. Therefore starting with syntax errors crossing semantic errors ending with changed behaviour (for example: case(in)sensitive comparison); everything is possible with the current versions of SAP DB. With later versions (> 7.4) some differences will not occur any more, some will remain. Please do not ask, which one will fall in which list, we are just checking every single point one by one. > What problems migrating from PostgreSQL to SAP DB? > What are the solutions? > > I have been asked for a tool to dump the schema from a MySQL > database that > could be imported into a new SAP DB database. I'm guessing > that loadercli > will be able to import the schema if it is formatted > correctly. Are there > any current plans to write a schema dump tool for MySQL that > will create > files that can be used by loadercli to import into SAP DB? As said above, we are just in the phase of planning activities. No answer can be given so far. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
