Question Related Database transfer in sql

Question

0.00/5 (No votes)

See more:

SQL-Server

SQL-Server-2008

Hi All,
If any one tell me by which i can transfer table from one sql server database to another sql server database.

Posted 10-May-13 21:10pm

shubham Dev

Add a Solution

3 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)

RAGINEE TRIPATHI · Answer 1 · 2013-05-10T21:17:00

Solution 3

1-RIGHT CLICK ON YOUR DATA BASE AND CHOOSE EXPORT/ OR IMPORT
2-THERE ARE WIZARD BY WHICH YOU CAN COPY SOME TABLE OR ALL INTO ANY FORM OF DATABASE.

OR
1-DISCONNECT YOUR DATABASE FROM SQL ENGINE.
2-COPY TWO FILE FROM PROGRAM FILES/MICROSOFT SQL/ MS1.1 OR MS1.2/ DATA/ YOUR DB NAME WITH EXT. .MDF AND .LDF
3-PASTE AT THE SAME PLACE AND CONNECT WITH SQL ENGINE.

Posted 10-May-13 21:17pm

RAGINEE TRIPATHI

Comments

shubham Dev 11-May-13 3:29am

I have copied schema from one server to another , all the table structure and sp's has been created but now i want to transfer those table's data from one server to another sql server d b

so suggest me by which i can test on single table data, and then i can apply on all tables
Thank's

Mehdi Gholam · Answer 2 · 2013-05-10T21:15:00

Solution 1

Read the following :

http://stackoverflow.com/questions/2927199/copy-data-from-one-sql-server-database-table-to-the-other[^]

http://geekswithblogs.net/phoenix/archive/2009/01/28/sql-server---moving-data-across-servers-using-a-linked.aspx[^]

Posted 10-May-13 21:15pm

Mehdi Gholam

Comments

shubham Dev 11-May-13 3:29am

I have copied schema from one server to another , all the table structure and sp's has been created but now i want to transfer those table's data from one server to another sql server d b

so suggest me by which i can test on single table data, and then i can apply on all tables
Thank's

Mehdi Gholam 11-May-13 3:46am

If you want to copy all the data as well then just backup and restore the database. The links above show you how to filter and copy data with queries.

shubham Dev 11-May-13 3:56am

But I want some specific table's data , because there are several tables those data are unused .Thanks

Mehdi Gholam 11-May-13 4:00am

The links are pretty clear if you read them.

Mohammed Hameed · Answer 3 · 2013-05-10T21:15:00

Solution 2

You have to create transfer package in SQL Server and execute it.

You can schedule it as well by creating a SQL job for it.

Posted 10-May-13 21:15pm

Mohammed Hameed