DBA – MySQL, PostgreSQL, MongoDB, Oracle
Posts consists of software engineering how-to, analysis, designing tools, UML, database design and process flow.
Background: One of my development project initially was on SQL Server as backend database. But consistently facing problem of ‘ODBC failed to connect’ throughout a year. The database was the SQL Server XE. Convinced to transfer my database to Oracle as it is very reliable on ODBC connection. So intended to initiate a database design migration from…
Prerequisite: To import relational databases schema into Enterprise Architect, first make an ODBC data source for your database. You have to ensure that the ODBC driver matches your Enterprise Architect processor architecture requirement(32 or 64 bit). For the purpose of various kinds of UML documentation for the eBiz project. I had to import SQL server…