5

Copy Data from One SQL Instance to Another

Posted by Sameer on February 3, 2009 in Programming |

When using SQL Server Management Studio you might want to copy data from one DB to another (using just a SELECT and INSERT statement) It’s so easy you won’t believe it sp_addlinkedserver @server='192.168.123.456', @provider='SQLNCLI',    @srvproduct='',@provstr='User Id=sa; Password=are-you-crazy-to-use-sa' insert into [192.168.123.456].MYDB.dbo.tblRecords select * from MYDB.dbo.tblRecords and when you are done sp_dropserver [192.168.123.456] References: sp_addlinkedserver on MSDN […]

Copyright © 2007-2014 SharpDeveloper now AgileChai All rights reserved.
This site is using the Desk Mess Mirrored theme, v2.0.2, from BuyNowShop.com.