1.Install an instance of SQL 2008 R2 on one machine and SQL 2008 on another
2.Open SQL Server Management Studio R2
3.Select your source Database
4.Select Tasks>Generate Scripts.
5.Select 'Script entire database and all database objects', press 'Next'
6.Select 'Save to File' and click on the 'Advanced' button
7.Select 'Script for Server Version' and select the version you want: 200/2005/2008
8.Select 'Type of data to Script' and select Schema/Data/both
9.Click 'OK',Next and do it!
10.Copy the resulting file to the target machine with SQL 2008 [or whatever]
11.Log onto your SQL Management Studio and open the copied .sql file... be aware that there may be limitations on the file size.
There may also be issues with the order that the .SQL file inserts the data into the target database and if there are FK constraints in place, this could be an issue.... simply re-order the insert lists.
12.Once the .sql file is organised, parse it [just to sure], and then execute.
分享到:
相关推荐
中文名: SQL Server 2008 R2详解手册 原名: Microsoft SQL Server 2008 R2 Unleashed 作者: Ray Rankins Paul Bertucci Chris Gallelli Alex T.Silverstein 资源格式: PDF 版本: 影印版 出版社: Sams书号: 978-...
全面, 深入的讲解SqlServer数据库的各种备份和恢复策略和方案
SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on ...
在sql server 2008 r2 版本中还原从sql server 2005备份出来的数据库时,提示错误:RESTORE DATABASE 正在异常终止。 (Microsoft SQL Server,错误: 3154)。
本文讲解了完全摆脱共享存储的sqlserver双机实施方案,有兴趣的小伙伴可以下载看看。本文是根据本人多年实施的经验而写,已经将实施中可能遇到的坑基本填平,欢迎同行下载浏览,有疑问的欢迎留言!
RESTORE DATABASE命令还原SQLServer 2005 数据库
Understand the importance of a fully implemented backup plan in SQL Server Agent Integrate backup and restore techniques into an existing environment Consider space and time requirements for backup...
本代码使用的默认数据库环境是MS SQL Server, study_bak是从MS SQL Server中BACKUP出来的库文件。 在使用前请先RESTORE到study库中。 如果restore失败,可以用study.sql脚本创建所有表格与视图并自行添加数据。
sqlserver一般是用SSMS通过任务的使用bak文件或分离文件进行还原。但是对于少数有人使用backup命令将数据库备份为了dat文件,不知道怎样还原,这里提供使用dat文件恢复数据库完整语句 。
CHAPTER 4 Installing Microsoft SQL Server 2008 . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 CHAPTER 5 Upgrading to Microsoft SQL Server 2008 . . . . . . . . . . . . . . . . . . . . . . ....
Chapter 31: Backup and Restore Chapter 32: High Availability Technologies Part VII: Columnstore Indexes Chapter 33: Column-Based Storage and Batch Mode Execution Chapter 34: Columnstore Indexes Part...
Useful when you do not have access to a SQL Server instance and need to know what’s contained in a backup file, or when you cannot restore a backup file and want to know which version of SQL Server ...
SQL SERVER数据库备份恢复演示程序,使用TSQLQuery完成。
VB实现的人事管理系统源代码+数据库SQL Server2014+程序说明。 一、本系统由以下对象组成: 1.窗体 (1)AddUser:添加用户; (2)Backup:数据库备份; (3)delete_staff:删除职员数据; (4)Login:系统...
用delphi 7编写的还原备份SQL Server 2005 数据库的程序。-Written with delphi 7 to restore the backup of SQL Server 2005 database program.
SQL Server中误删除数据的恢复本来不是件难事,从事务日志恢复即可。但是,这个恢复需要有两个前提条件: 1. 至少有一个误删除之前的数据库完全备份。 2. 数据库的恢复模式(Recovery mode)是“完全(Full)”。 ...
example of restore db sql server
(2) 使用Backup Database和Restore Database命令备份和还原数据库。注意,在备份和还原中都要指定完整的路径和文件名。 (3) 使用SQL Server Management Studio备份和还原数据库。利用可视化的操作界面实现备份和还原...
如何将SQLServer 数据库中的数据和用户信息恢复到一个新的SQLServer环境中