将数据从 SQL Server 2008 复制到 SQL Express
我想将数据库（表、数据、存储过程和视图）从 SQL Server 2008 数据库复制到 SQL Server Express。是否可以？如果是这样，请让我知道该怎么做吗？当我尝试时，它给出了一些错误。
请注意，我在 SQL Server 2008 数据库表中只有很少的记录。
谢谢和问候.. 什鲁蒂·克尔蒂..
I would like to copy a database (tables, it’s data, stored procs & views) from SQL Server 2008 database to SQL Server Express. Is it possible? If so, would you please let me know how to do it? When I tried, it is giving some error.
Please note that I have only few records in SQL Server 2008 database tables.
Thanks and Regards..
Shruthi Keerthi..
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
最快的方法是将源数据库与其服务器“分离”，将 (2) 个文件复制到新的名称/位置，并将每个数据库（重新）附加到适当的服务器。
附加/分离可作为命令或通过 SQL Visual Studio 使用。
The quickest way is to "detach" the source database from its server, copy the (2) files to a new name/location and (re)attach each database to the appropriate server.
Attach/detach is available as a command or via the SQL Visual Studio.
您可以创建数据库的备份，然后将该备份恢复到 Express 实例中。
另一个选择是，因为您说数据库中没有太多记录，所以生成 SQL 语句（右键单击数据库 --> 任务 -> 生成脚本），然后在 Express 实例上运行它。然后只需复制您想要的元组即可。
You can create a backup of the database and them restore that backup into the Express instance.
Another option, since you said you didn't have very many records in the DB, is to generate the SQL statements (right click on the database --> tasks -> generate scripts) and then run that on the Express instance. Then just copy over the tuples you want.
当将数据库从一台服务器移动到另一台服务器时，我更喜欢使用备份/恢复。只要您的 SQL Server 和 SQL Express 是同一版本，或者您要迁移到的版本比您要迁移的版本（SQL 2005 到 SQL Express 2008）更新，它就应该可以顺利运行。
I prefer to use Backup/Restore when moving a database from one server to another. As long as your SQL Server and SQL Express are the same version, or the one you are moving to is newer than the one you are moving from (SQL 2005 to SQL Express 2008), it should work without a hitch.
如果复制整个数据库，我通常发现最简单的方法是停止源服务，将 *.mdf 文件复制到相应的新数据目录，然后将 MDF 挂载到新服务中。只要设置没有任何更改（例如 FILESHARE），那么这就是克隆数据库的最简单方法。
是的，这是可能的。我今天早些时候刚这样做过。
If copying the entire database, I usually find it easiest to stop the source service, copy the *.mdf file to the appropriate new data directory, and just mount the MDF in the new service. As long as there aren't any changes in the setup (like FILESHARE), then this is the easiest way to clone a database.
And yes, this is possible. I just did this earlier today.
您还可以尝试使用 Microsoft 数据库发布向导。
它使用简单，将创建一个 SQL 脚本，您可以运行该脚本来重建表（包括数据）、存储过程、视图等...
您可以在此处下载：
http://www.microsoft.com/downloads/ details.aspx?FamilyID=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en
You could also try using the Microsoft Database Publishing Wizard.
It's simple to use and will create a SQL script that you can run to rebuild tables (including data), stored procs, views, etc...
You can download it here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en