So far i have used(slightly or widely) these databases: mysql, Ms Access, Oracle, Sql Server. Previously i was engaged with only mysql database. but now a days, i need to work wiith different type of databases. more specifically, i receive different kind of databases and i need to analyze and report based on that. in order to do that, i need a descent converter who is able to convert any database to any database. i found some tools described here.
First tool is Navicat Mysql. this is a very good software which have a lot of features. really powerful and able to handle any kind of request when it’s mysql related. in contrast, navicat is not good to handle oracle or mysql server. although, it have features like, you can convert a mysql database to Ms Access or generate sql script. i am slightly happy but not totally.
Second tool i found is sqldeveloper by oracle. currently analyzing this one. so far i found this is another good tool when target or source database is oracle. but not sufficient enough to convert sql server to mysql or ms access. moreover, this tool don’t have reporting feature itself included. however, this is another powerful tools for database migration.
Thirdly, there are hundreds of free or commercial version softwares who are able to convert from one database to another. but those are really painful to test one by one (due to unstability).
Filed under: Code Igniter, Framework | Tags: backup script, ci database backup, database backup, mysql database backup, mysql db backup
Easy way to backup of database(mysql) using CI
$this->load->dbutil();
$this->load->helper(‘download’);
$this->load->helper(‘file’);
$prefs = array(
‘tables’ => array(), // Array of tables to backup.
‘ignore’ => array(’ssc_dakhil_exam’), // List of tables to omit from the backup
‘format’ => ‘zip’, // gzip, zip, txt
‘filename’ => ‘mybackup.zip’, // File name – NEEDED ONLY WITH ZIP FILES
‘add_drop’ => TRUE, // Whether to add DROP TABLE statements to backup file
‘add_insert’ => TRUE, // Whether to add INSERT data to backup file
‘newline’ => “\n” // Newline character used in backup file
);
$backup =& $this->dbutil->backup($prefs);
//write_file(‘c:\mybackup.txt’, $backup);
force_download(‘mybackup.zip’, $backup);
Filed under: Oracle | Tags: oracle 10g, oracle 10g express edition, start oracle
After couple of weeks i am back in my dash board to write something. This time i come back here to write about ORACLE. we all knows that Oracle is very very strong and powerful database. so lets start really quick.
First of all, there are number of different version of Oracle. For example, oracle 8, 9i, 10g etc etc. Again 10g have different versions as well. i start with oracle 10g express edition. In order to download oracle 10g express edition goto OTN(Oracle Technology Network) and search for oracle 10g express edition. Download it from there.
Well, the time when i start learning (weeks back) i have no helper and feel that if someone guide me step by step then it would be helpful for me. From my BEST TEACHER i get an excellent tutorial. it shows me where from start and how to proceed. this tutorial guide me from 10g installation to application building and reporting. here is the link for you all: http://www.tutorialized.com/view/tutorial/Oracle-Database-10g-Express-Edition-Tutorial/37325
Well after gather some basics of oracle, i feel i need a tool to migrate my existing database into oracle. again from my BEST TEACHER i found it at http://www.oracle.com/technology/tech/migration/workbench/index.html
And right now i am Learning oracle. best of luck to me. ha ha
