MySQL to Oracle Migration Guide

By -


MySQL to Oracle Migration Guide

  1.   Add MySQL preference in OracleSQL developer for connecting MySQL databases.
2.                           Add destination oarcle connectioin in oracle sql developer.
                   Open below dialogue box and add mysql connector
             Tools > Preferences > Database > Third Party JDBC Driver




2. Then Mysql tab will enabled while creating New Connection
Configure and open desired database.




3. Select multiple custom tables or one by one then righ click.
Then press copy to oracle



5.       4. Select destination screen data base as mentioned in below dialogue box



6.       5. Finally verify table and data migrated to Oracle schema or not.

Comments

Post a Comment

Popular posts from this blog

SinglePass Terms of Service

By -
SinglePass Terms of Service It is important that you read this carefully because you will be legally bound to these terms. Your access to and use of the Service is based on your acceptance of and compliance with these Terms. These Terms apply to all users others who access or use the SinglePass application . By accessing or using the Service you agree to be bound by these Terms and accept all legal consequences. If you do not agree to the terms and conditions of this Agreement, in whole or in part, please do not use the SinglePass application . PREAMBLE Whereas The TechSaga (Anand Gunasekaran) has developed a SinglePass system through which it provides Customers with access to save their password or notes in his/her mobile phone or other mobile devices(the “Device”) and comprising of service options, as detailed in the TECHSAGA Mobile Service terms and conditions accessible on the TECHSAGA   Website ( https://outofboundexception.blogspot.com/2019/...
Read more

Jasper Report Viruatization

By -
Image
Jasper Report Viruatization There are certain things to care while implementing the Jasper Reports for huge data-set to handle the memory efficiently, so that the application does not go out of memory. Pagination of the data and use of JRDataSource Viruatization of the report. Problem:- When there is a huge data set, it is not a good idea to retrieve all the data at one time.The application will hog up the memory and you’re application will go out of memory even before coming to the jasper report engine to fill up the data Solution :- To avoid that, the service layer/Db layer should return the data in pages and you gather the data in chunks and return the records in the chunks using JRDataSource interface, when the records are over in the current chunk, get the next chunk until all the chunks gets over Even after returning the data in chunks, finally the report has to be a single file.Jasper engine build the JasperPrint object for this. To avoid the piling up of me...
Read more

JasperReports Tutorial

By -
Image
Jasper Report is an open source java reporting engine, is Java based and doesn't have its own expression syntax. As JasperReports is a Java class library, and is not meant for end users, but rather is targeted towards Java developers who need to add reporting capabilities to their applications Report template Generally the following report layout is followed to generate reports by many of the commercial report generating tools. Following is the description of each element mentioned in the diagram. Element Description title Title contains the title of the report. It appears only once at the very beginning of the report, for example, "Tutorials Point Report". pageHeader PageHeader may contain date and time information and/or organization name. This appears at top of each page. columnHeader ColumnHeader lists the names of those specific fields which you want to display in the report, for example, "Author Name", "Starting Hour", "Finis...
Read more