How to insert into table from one database to another database

Question

1.00/5 (1 vote)

See more:

hi,

Iam c# and Sql server 2005

i have to insert data from one database into another database.

one database is local and other is dyndns

ex:example.dyndns.org\server is my another database name

how can i insert into another database selecting the table from the local

insert into [example.dyndns.org\SERVER].[MainShopWork].[dbo.Inv_Brand]
select * from temp

but this is giving error

Regards
Nirmala devi

Posted 22-Jun-14 2:02am

Nirmala Saravanan

Add a Solution

Comments

[no name] 22-Jun-14 8:07am

http://www.google.com/search?q=How+to+insert+into+table+from+one+database+to+another+database

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)

PrakashCs.net · Answer 1 · 2014-06-22T02:28:00

Solution 1

try solution 1 from this link

http://stackoverflow.com/questions/3502269/how-to-insert-table-values-from-one-database-to-another-database[^]

Posted 22-Jun-14 2:28am

PrakashCs.net

CHill60 · Answer 2 · 2014-06-22T03:11:00

Further to solution 1 ... your code

SQL

insert into [example.dyndns.org\SERVER].[MainShopWork].[dbo.Inv_Brand]
 select * from temp

implies that you have a table called "dbo.Inv_Brand".

I suspect you actually have a table Inv_Brand for the schema/table owner dbo so your code should have read

SQL

insert into [example.dyndns.org\SERVER].[MainShopWork].[dbo].[Inv_Brand]
 select * from temp

By the way "is giving error" should have been followed by the wording of the error - we can't see your screen or see through your eyes to find out what the problem is.