insert into table in a database by selecting data from table in different database

Question

0.00/5 (No votes)

See more:

Still on the migration tool I have been working on. My question now is how do I insert records from a table in a database to a table in another database?.( this is actually the main data migration).
I have tried using the SQL "INSERT INTO...SELECT" statements but I am getting errors and I know its because I am connecting to both databases using separate connections.

NB:I have a SOURCE DATABASE which is the database containing tables I will be SELECTING FROM let's call it SOURCE_DB and I am connecting to it using a CONNECTION object called CONN1

NB:I have a DESTINATION DATABASE which is the database containing tables I will be inserting into. Let's call it DEST_DB and I am connecting to it using a CONNECTION object called CONN2

NB:Programming language is C# and database is Sybase SQLAnywhere

Please guys any help, tip or tutorial on how to solve this will be highly appreciated.

Posted 17-Oct-13 5:59am

Uzoma Umekwe

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nelek · Answer 1 · 2013-10-17T06:04:00

SQL is not my expertise field, but a job-mate of mine had a similar issue, he solved it using:

http://www.mssqltips.com/sqlservertip/1704/using-merge-in-sql-server-to-insert-update-and-delete-at-the-same-time/[^]

I don't know if it can help you directly, but maybe it gives you another point of view to find the way.

(If not you can always try to ask that guy, he looks to know a lot about it)

Ravndra22 · Answer 2 · 2013-10-17T19:31:00

Solution 2

You can use query like
select * into [Destination Server][Databasename].[dbo].[Tablename1] from [Source server].[Databasename].[dbo].[Tablename2]

Remember Tablename2 should not present initially.

Posted 17-Oct-13 19:31pm

Ravndra22