将表数据从本地SQL Server插入到远程sqlserver表 [英] Insert table data from local sql server to remotely sqlserver table

问题描述

任何人都可以帮助我，将本地sqlserver中的一个表中的数据插入到另一台计算机中的另一台sql server中.

借助query.Import/Export向导将不被使用..


请帮帮我!!!!!!!



问候
Seema

Hi,

Anyone can help me, to insert data from one table that is in local sqlserver into another sql server that is another machine.

With the help of query.Import/Export wizard will not be use..


Please help me!!!!!!!



Regards
Seema

推荐答案

看看这个:

http://kb.dotnetpark.com/Article.aspx?ArticleID=1017 [ ^ ]

Look at this:

http://kb.dotnetpark.com/Article.aspx?ArticleID=1017[^]

如果"只是想一次迁移数据，导入/导出向导可以提供帮助: http://go .microsoft.com/fwlink/p/?LinkId = 167982 [ ^ ].

SQL Server集成服务也可以提供帮助(即使您不需要迁移和更改架构)，但是SQL Server 2008中可能已经引入了该服务.

如果您需要定期执行此操作，则可以重新考虑您的设计.这可能很昂贵，并且容易合并错误.相反，您可以做的是将数据库复制到其他服务器.请参阅 http://msdn.microsoft.com/en-us/library/ms151198(v = SQL.90).aspx [

If you''re just looking to migrate data one-time, the import/export wizard can help: http://go.microsoft.com/fwlink/p/?LinkId=167982[^].

SQL Server Integration services can also help (even if you don''t need to migrate and change the schema) but that may have been introduced in SQL Server 2008.

If you need to do this regularly, you may rethink your design. This can be expensive and prone to merge errors. What you could do instead is replicate the database to other servers. See http://msdn.microsoft.com/en-us/library/ms151198(v=SQL.90).aspx[^].

这篇关于将表数据从本地SQL Server插入到远程sqlserver表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！