使用 SQL Server Management Studio 将表从一个 SQL Server 和数据库复制到另一个 SQL Server Management Studio
我有一个使用数据库开发的网站，并且在该网站上创建了一些安全措施。这将创建另一个名为 ASPNETDB.MDF 的数据库。
主站点数据库位于网站主机的服务器上。 此时aspnetdb位于我网站的APP_DATA文件夹中。
我想将表及其数据从 aspnetdb 复制到主数据库。 我已在 SQL Server Mgt studio 中连接到两者。我右键单击要复制的表之一，然后选择“AScript 表”>“创建到”>“新查询”。 我将查询复制并粘贴到我想要将表复制到的数据库的新查询并运行查询。 查询的第一行是：
USE [\C:\WEBSITES\CHAMBEROFCOMMERCE - WITH SECURITY\APP_DATA\ASPNETDB.MDF]
GO
/****** Object: Table [dbo].[aspnet_Users] Script Date: 12/09/2009 14:20:00 ******/
SET ANSI_NULLS ON
GO
第一行被错误地认为不存在。 大概是因为它在我尝试复制到的服务器上不存在。我应该使用什么语法来指向正确的数据库？
I have a website I have developed using a databse and I have created some security on the site. This ceates another DB called ASPNETDB.MDF.
The main site database is on a server at the website host.
At this time the aspnetdb is in the APP_DATA folder of my website.
I want to copy the tables and their data from the aspnetdb to the main database.
I have connected to both in SQL Server Mgt studio. I right clicked one of the tables I want to copy and selected AScript Table>Creat to>New Query.
I copied and pasted the query to a new query for the database I want to copy the table to and ran the query.
the first lines of the query are:
USE [\C:\WEBSITES\CHAMBEROFCOMMERCE - WITH SECURITY\APP_DATA\ASPNETDB.MDF]
GO
/****** Object: Table [dbo].[aspnet_Users] Script Date: 12/09/2009 14:20:00 ******/
SET ANSI_NULLS ON
GO
The first line is errored as not existing.
Presumably because it does not exist on the server I am trying to copy to. What syntax should i use to point at the correct database please?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
对于这种任务，我们使用
SQL Compare
这是一个真正的非常好用的工具，并使这些任务变得非常简单。
For this kind of task, we use
SQL Compare
This is a realy very nice tool to use, and makes these task very simple.
该行告诉它使用本地数据库。如果您要在托管服务器上的数据库中创建查询，您可以（应该）删除它。也就是说，您右键单击托管服务器中的数据库并选择“新建查询”——这将自动将查询连接到要在其中创建表的数据库。
如果您只是更改脚本上的连接，则需要将其替换为远程系统上数据库的 USE 语句。
顺便说一句，我还推荐 Red Gate 的 SQL Compare——在我看来，这是更好的工具。
That line is telling it to use the local database. You can (should) remove it if you are creating a query in the database on your hosting server. That is, you right-click on the DB in the hosting server and choose New Query -- that will automatically connect the query to the database in which to create the tables.
If you are simply changing the connection on the script, then you will need to replace it with a USE statement for the database on the remote system.
BTW, I'd also recommend SQL Compare from Red Gate -- much better tool for the job, IMO.