postgresql - Copying Data from Oracle to Postgres -

-

We have a daily process that draws all the statistics of several tables in the Oracle database and imports them in postages (Enterprise DB) Database - Version 8.4.

We are currently using the Java application to select * from each table, change the keyword (date, timestamp, etc.) and then import them into a Postgrass database.

Is any tool available in postgrad, which will provide a more efficient way of doing this? I should note that there are COBBs which are being taken over.

There is one migration tool once, but it can also work in your case. I accept it as an Oracle-to-Postgresqual PG_dump.

Comments

Post a Comment

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

-
I have developed an extension which works up to 1.6 on Magren (I'm trying Enterprise Edition, And I think the community is the same problem, because it is the same code). In my install script, I see the $ installer-> gt; CreateEntityTables ($ this- & gt; getTable ('alphanum / info')); The installation is done until it is not in the _text unit table. It crashed there! It turns out that when I log in to SQL and run it via PHPmyadmin, then this error is: Blob / Text column 'value' is used without the key 'key' . I saw the code there, and this is what is trying to create an index on the value column: -> addIndex ($ this- & gt; getIdxName ($ eavTableName, array ( 'attribute_id array (' attribute_id ',' value ')) - & gt; addIndex ($ this- & gt; getIdxName ($ eavTableName, array (' entity_type_id ' , 'Value')), array ('entity_type_id', 'value')) If there is no if statement is n...
Read more

ruby on rails - Convert a Activerecord result with has_one associations into a single hash per record -

-
If I have any results from the Active Records, then I have an array of hashes, if I have a reliable load, then every Each organization hash in record hash has a nested hash of its associated records My question is, is there a quick rail system that allows you to merge these nested hashes into a hash per record? An analogy will be changing the records table rows Another resemblance will be converted into a hash at one level of nested hashes. approach 1: select them in the section Include class user has_one: profile end is for square profile: user # street 1, street 2, city etc. end profile = profile.junks (user :). Selection ("User. *, Profile. *") All profiles. First.login Approach 2: Use delegation for class profiles : User # Street 1, Road 2, City etc. Representative: Name ,: name =,: email,: email = ,: from = to & gt; : End of user
Read more

c# - GetType() == type perfomance question -

-
I am making an XNA game and I am calling the following updates 2 to 20 times the code. I tried googling and it seems that it is half slow, so I thought I was asking what kind of fast way to compare the type? code: Public modifier for this [type type] {for (int i = 0; i & lt; this.Qount; i ++) {if ( It [I.] Type GETType () ==) {Please return this [ii]; }} New NotImplementedException Throw ("Fix It"); } Set {for (int i = 0; i & lt; this.Qount; i ++) {if (this [i]. Type GetType () ==) {this [i] = value; }} If (System. Diagnostics.Debugor.ISAcredited) system. Diagnostics. Debugger. Break (); }} This code is in the modifier collection section which comes from a list. The modifier is a part of the particle engine. In addition, my game is not in a situation where I can actually do this test, so I can not test it, but should it work right? I read something about runtime typhanies, which is fast, should I use it? Thanks a lot! Edit: What I'm aiming to do ...
Read more