Query to copy rows from sql server to another sql server (using query)

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi,
I have two sql servers, SE1 and SE2, they are basically having the same schema, but each one has its own usability.
I need to find a query to copy some rows from SE1.Table1 Where Destination Like '%HR%' to SE2.Table2.
Is there such query ??
Thx in advance.

Posted 24-Feb-14 1:15am

saleem_deek

Updated 16-Mar-14 21:25pm

v2

Add a Solution

4 solutions

Solution 2

SQL

insert into SE1.table1 (column1,comumn2,colum3) select col1,col2,col3 from SE2.table2  Where SE2.table2.Destination Like '%HR%'

Posted 24-Feb-14 1:37am

King Fisher

Updated 24-Feb-14 1:38am

v3

Solution 1

Check this links.

http://stackoverflow.com/questions/2927199/copy-data-from-one-sql-server-database-table-to-the-other[^]
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f5ee85c7-c9d3-438e-a835-daa2c785026b/copy-sql-database-tables-to-another-sql-server?forum=sqlgetstarted[^]

Posted 24-Feb-14 1:29am

ArunRajendra

Solution 4

use import or export data....:)

Posted 14-Mar-14 7:35am

Pranav-BiTwiser

Comments

saleem_deek 17-Mar-14 3:27am

Thank you Pranav :)
But I needed to achieve that using queries, I didn't specify that in the title, my bad, but I updated it now.

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)

saleem_deek · Accepted Answer · 2014-03-14T06:03:00

Solution 3

Solution is there:
http://stackoverflow.com/questions/21987481/query-to-copy-rows-from-sql-server-to-another-sql-server/21987731#21987731[^]

Posted 14-Mar-14 6:03am

saleem_deek