将表数据从本地SQL Server插入到远程sqlserver表
问题描述：
任何人都可以帮助我，将本地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[^].