dbTalk Databases Forums  

howto copy results from one database to another?

comp.databases comp.databases


Discuss howto copy results from one database to another? in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bogdan Slusarczyk
 
Posts: n/a

Default howto copy results from one database to another? - 01-09-2008 , 05:24 AM






Hi everyone, I want to copy query results from read-only database to
another database, do you know any handy tool which can help me? I use
squirrel but it can't directly create new table with query result inside
database which is different from source database (I have to create
proper table by hand and copy results using sql query).

Regards
Bogdan

Reply With Quote
  #2  
Old   
Ed Prochak
 
Posts: n/a

Default Re: howto copy results from one database to another? - 01-10-2008 , 11:30 AM






On Jan 9, 6:24*am, Bogdan Slusarczyk <bodzio... (AT) op (DOT) pl> wrote:
Quote:
Hi everyone, I want to copy query results from read-only database to
another database, do you know any handy tool which can help me? I use
squirrel but it can't directly create new table with query result inside
database which is different from source database (I have to create
proper table by hand and copy results using sql query).

Regards
Bogdan
NO mention of the source database
NO mention of the destination database
NO mention of source or destination platforms (Operating Systems)
NO mention if the databases are even on the same machine or on
different planets.

We are not mind readers.

If the databases are different, and on different platforms/machines,
you typically develop a interface using:
speacial features of the database products
or common connection methods (ODBC)
or flat file transfers and loads

Since your question was so generic, so was my answer.
Ed


Reply With Quote
  #3  
Old   
Ed Prochak
 
Posts: n/a

Default Re: howto copy results from one database to another? - 01-10-2008 , 11:30 AM



On Jan 9, 6:24*am, Bogdan Slusarczyk <bodzio... (AT) op (DOT) pl> wrote:
Quote:
Hi everyone, I want to copy query results from read-only database to
another database, do you know any handy tool which can help me? I use
squirrel but it can't directly create new table with query result inside
database which is different from source database (I have to create
proper table by hand and copy results using sql query).

Regards
Bogdan
NO mention of the source database
NO mention of the destination database
NO mention of source or destination platforms (Operating Systems)
NO mention if the databases are even on the same machine or on
different planets.

We are not mind readers.

If the databases are different, and on different platforms/machines,
you typically develop a interface using:
speacial features of the database products
or common connection methods (ODBC)
or flat file transfers and loads

Since your question was so generic, so was my answer.
Ed


Reply With Quote
  #4  
Old   
Ed Prochak
 
Posts: n/a

Default Re: howto copy results from one database to another? - 01-10-2008 , 11:30 AM



On Jan 9, 6:24*am, Bogdan Slusarczyk <bodzio... (AT) op (DOT) pl> wrote:
Quote:
Hi everyone, I want to copy query results from read-only database to
another database, do you know any handy tool which can help me? I use
squirrel but it can't directly create new table with query result inside
database which is different from source database (I have to create
proper table by hand and copy results using sql query).

Regards
Bogdan
NO mention of the source database
NO mention of the destination database
NO mention of source or destination platforms (Operating Systems)
NO mention if the databases are even on the same machine or on
different planets.

We are not mind readers.

If the databases are different, and on different platforms/machines,
you typically develop a interface using:
speacial features of the database products
or common connection methods (ODBC)
or flat file transfers and loads

Since your question was so generic, so was my answer.
Ed


Reply With Quote
  #5  
Old   
Gene Wirchenko
 
Posts: n/a

Default Re: howto copy results from one database to another? - 01-10-2008 , 06:15 PM



Ed Prochak <edprochak (AT) gmail (DOT) com> wrote:

Quote:
On Jan 9, 6:24*am, Bogdan Slusarczyk <bodzio... (AT) op (DOT) pl> wrote:
Hi everyone, I want to copy query results from read-only database to
another database, do you know any handy tool which can help me? I use
squirrel but it can't directly create new table with query result inside
database which is different from source database (I have to create
proper table by hand and copy results using sql query).

NO mention of the source database
NO mention of the destination database
NO mention of source or destination platforms (Operating Systems)
NO mention if the databases are even on the same machine or on
different planets.
NO mention of the DBMS. (SQuirreL does not appear to be a DBMS but a
related tool.)

Quote:
We are not mind readers.
I knew you were going to say that, Ed.

When will people learn? Maybe if they read Eric Steven Raymond's
"How To Ask Questions The Smart Way" at
<http://www.catb.org/~esr/faqs/smart-questions.html>.

Quote:
If the databases are different, and on different platforms/machines,
you typically develop a interface using:
speacial features of the database products
or common connection methods (ODBC)
or flat file transfers and loads

Since your question was so generic, so was my answer.
Same with mine.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.


Reply With Quote
  #6  
Old   
Gene Wirchenko
 
Posts: n/a

Default Re: howto copy results from one database to another? - 01-10-2008 , 06:15 PM



Ed Prochak <edprochak (AT) gmail (DOT) com> wrote:

Quote:
On Jan 9, 6:24*am, Bogdan Slusarczyk <bodzio... (AT) op (DOT) pl> wrote:
Hi everyone, I want to copy query results from read-only database to
another database, do you know any handy tool which can help me? I use
squirrel but it can't directly create new table with query result inside
database which is different from source database (I have to create
proper table by hand and copy results using sql query).

NO mention of the source database
NO mention of the destination database
NO mention of source or destination platforms (Operating Systems)
NO mention if the databases are even on the same machine or on
different planets.
NO mention of the DBMS. (SQuirreL does not appear to be a DBMS but a
related tool.)

Quote:
We are not mind readers.
I knew you were going to say that, Ed.

When will people learn? Maybe if they read Eric Steven Raymond's
"How To Ask Questions The Smart Way" at
<http://www.catb.org/~esr/faqs/smart-questions.html>.

Quote:
If the databases are different, and on different platforms/machines,
you typically develop a interface using:
speacial features of the database products
or common connection methods (ODBC)
or flat file transfers and loads

Since your question was so generic, so was my answer.
Same with mine.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.


Reply With Quote
  #7  
Old   
Gene Wirchenko
 
Posts: n/a

Default Re: howto copy results from one database to another? - 01-10-2008 , 06:15 PM



Ed Prochak <edprochak (AT) gmail (DOT) com> wrote:

Quote:
On Jan 9, 6:24*am, Bogdan Slusarczyk <bodzio... (AT) op (DOT) pl> wrote:
Hi everyone, I want to copy query results from read-only database to
another database, do you know any handy tool which can help me? I use
squirrel but it can't directly create new table with query result inside
database which is different from source database (I have to create
proper table by hand and copy results using sql query).

NO mention of the source database
NO mention of the destination database
NO mention of source or destination platforms (Operating Systems)
NO mention if the databases are even on the same machine or on
different planets.
NO mention of the DBMS. (SQuirreL does not appear to be a DBMS but a
related tool.)

Quote:
We are not mind readers.
I knew you were going to say that, Ed.

When will people learn? Maybe if they read Eric Steven Raymond's
"How To Ask Questions The Smart Way" at
<http://www.catb.org/~esr/faqs/smart-questions.html>.

Quote:
If the databases are different, and on different platforms/machines,
you typically develop a interface using:
speacial features of the database products
or common connection methods (ODBC)
or flat file transfers and loads

Since your question was so generic, so was my answer.
Same with mine.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.