TUniDump and Oracle
TUniDump and Oracle
I use TUniDump with MySQL and it works great. Should it also work with Oracle? I have TUniConnection to Oracle server and able use TUniquery to find number of records in a table. Using the same connection and TUniDump creates exception with BackupToFile() procedure. Also getting tablenames from connection works. Oracle version is 11R2, 32bit client using UniDAC 7.2.5.
Re: TUniDump and Oracle
UniDump when working with OracleUniProvider does not have the capabilities available when using MySQLUniProvider. You can use UniDump to compose a script for inserting data from certain Oracle tables specified in the UniDump.TableNames property
Re: TUniDump and Oracle
Ok, the short answer would be that UniDump works only with MySQL databases and providers? Documentation does not give such a clear view. Might be easier to work with UniQuery in case Oracle database.
Re: TUniDump and Oracle
I am using UniDump on PostgreSQL, SQLite, SQL Server. As to my knowledge it works on all database systems. However, each database system has different support for "bulk loading". UniLoader is designed to bulk load data.
However, each database system has different or no support for bulk loading. You should be able to use it with Oracle (I do not have Oracle to test). However, same data might load faster when used with MySQL, or it maybe slower on FirebirdSQL or some other database system. It all depends on database system itself.
I believe short answer would be: UniDump loads data as fast as possible depending on database system that data is loaded into.
However, each database system has different or no support for bulk loading. You should be able to use it with Oracle (I do not have Oracle to test). However, same data might load faster when used with MySQL, or it maybe slower on FirebirdSQL or some other database system. It all depends on database system itself.
I believe short answer would be: UniDump loads data as fast as possible depending on database system that data is loaded into.
Re: TUniDump and Oracle
The functionality you are interested in is present in our product dbForge Studio : https://www.devart.com/dbforge/oracle/s ... tures.html
If you need these functions in UniDAC when working with Oracle DB, you can leave your suggestions at our UserVoice page http://devart.uservoice.com/forums/1046 ... 939-unidac, and if there are many votes for your suggestion, we will implement it.
If you need these functions in UniDAC when working with Oracle DB, you can leave your suggestions at our UserVoice page http://devart.uservoice.com/forums/1046 ... 939-unidac, and if there are many votes for your suggestion, we will implement it.