how to transfer data from one sql server pc to another sql server pc?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

hello friends...

i have two server named server-A and server-B. both servers have sql server 2008 and have same editions. i need to transfer table data from server-A to server-B. how to solve this?

Posted 12-Oct-14 21:02pm

TAUSEEF KALDANE

Add a Solution

1 solution

Add a Solution

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

Mehdi Gholam · Answer 1 · 2014-10-12T21:59:00

Solution 1

Backup and restore is usually how it is done with a little file copy in the middle.

Back Up and Restore of SQL Server Databases[^]

http://www.howtogeek.com/50354/restoring-a-sql-database-backup-using-sql-server-management-studio/?PageSpeed=noscript[^]

Posted 12-Oct-14 21:59pm

Mehdi Gholam

Comments

TAUSEEF KALDANE 13-Oct-14 4:21am

i need to transfer data between two servers through sql query and it has to update automatically after every 1 hour

Mehdi Gholam 13-Oct-14 4:24am

Then you need replication : http://msdn.microsoft.com/en-us/library/ms151198.aspx

how to transfer data from one sql server pc to another sql server pc?

1 solution

Solution 1

Add your solution here

Preview 0

how to transfer data from one sql server pc to another sql server pc?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us