Hi. I have two databases, I'd like to make a INSERT INTO database1.table ( SELECT * FROM database2.table ); Is it possible? I'd like this rather than export manually and import later. I'd like to keep the script SQL. asked 13 May '10, 12:28 Ismael Volker Barth |
You can use proxy tables for that - have a look at the Remote Data Access feature. Basically, you have to do the following in database 1:
Then you can access that remote table under the name table2, such as
Note, however, that the performance to access remote data might be much slower compared to local access. This is particularly true if you are joining over local and remote data. Nevertheless, this is a very useful feature. answered 13 May '10, 19:03 Volker Barth Thanks for the guidelide! I need help with this and I am misunderstanding some basic concepts. I will try to keep my ignorance simple. I test my sql statements in isql sybase 10. I can never seem to get items to work. First am I thinking wrong? can I do the above in isql for testing before I write my vb6 code? or is it tested in another interface?
(16 May '12, 12:43)
George
Replies hidden
Yes, you can run this code in Interactive SQL (and for testing or "learning" I would strongly recommend to use ISQL - or Sybase Central - over using any data access API). Are you gettting errors from your statements?
(16 May '12, 12:56)
Volker Barth
|
Like I told you today at office, it's possible! But is too much work for just few tables and 1 import operation. In this case, I think the better option is unload/reload.