如何传输具有数据结构的数据库 [英] How to transfer a Database with structure with data

问题描述

大家好，

我在使用SQL Server时遇到问题.

我在2005年有一个大约70MB大小(带有数据)的数据库，它在69个服务器中.现在，我在174服务器中创建了另一个数据库，我想将具有数据库结构的所有数据传输到新服务器，同时所有表结构和数据以及过程都相同.

请帮助我解决这个问题.我不喜欢在新数据库中编写脚本并执行它的方式.

除了脚本之外，还有其他任何新方法吗?

-JAGADiSH

hi to all.,

i have problem with SQL Server.

i have a database in 2005 with around 70MB size(with data), it is in 69 server. Now i have created another one database in 174 server and i want transfer all the data with database structure to the new server, with same all table structure and data and also procedures.

Please help me to come out of this problem. I dont like the way of scripting and executing it in new database.

is there any other new way other than the scripting ??

-JAGADiSH

推荐答案

从69服务器上备份数据库，并将.bkp文件复制到174服务器上并进行还原.

以下文章将说明如何取回数据库.

http://msdn.microsoft.com/en-us/library/ms177429.aspx [ ^ ]

Take the backup of database from 69 server and copy the .bkp file to 174 server and restore it.

The below article will explain how to retrieve database back.

http://msdn.microsoft.com/en-us/library/ms177429.aspx[^]

尝试此链接.



http://blog.sqlauthority .com/2007/02/25/sql-server-restore-database-backup-using-sql-script-t-sql/ [

Try this link.



http://blog.sqlauthority.com/2007/02/25/sql-server-restore-database-backup-using-sql-script-t-sql/[^]

这篇关于如何传输具有数据结构的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！