![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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 |
#5
| |||
| |||
|
|
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 |
|
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. |
#6
| |||
| |||
|
|
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 |
|
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. |
#7
| |||
| |||
|
|
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 |
|
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. |
![]() |
| Thread Tools | |
| Display Modes | |
| |