如何将数据从一台sql server pc传输到另一台sql server pc？ [英] how to transfer data from one sql server pc to another sql server pc?

问题描述

你好朋友......



我有两个名为server-A和server-B的服务器。两台服务器都有sql server 2008并且具有相同的版本。我需要将表数据从服务器A传输到服务器-B。如何解决这个问题？

解决方案

备份和恢复通常是在中间使用一个小文件复制的方式。



备份和还原SQL Server数据库 [ ^ ]



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

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?

解决方案

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[^]

这篇关于如何将数据从一台sql server pc传输到另一台sql server pc？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！