September 8, 2014 at 4:47 am
hi ALl,
can you please provide the possible ways to do this task.
September 8, 2014 at 4:59 am
kbhanu15 (9/8/2014)
hi ALl,can you please provide the possible ways to do this task.
Easiest would be to use Import Wizard of sql server, fetch the data from the source
create a staging(new) table and dump the data in that table.
September 8, 2014 at 5:00 am
thank you
September 8, 2014 at 5:12 am
you are welcome.
September 8, 2014 at 6:39 am
Other choices include using SQL Server Integration Services (SSIS), bulk insert, linked servers and regular t-sql, or just use a programming or scripting language to connect to both servers. You could do the last thing through PowerShell.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
September 9, 2014 at 6:32 pm
1.
SELECT *FROM OPENDATASOURCE( 'SQLOLEDB', 'Data Source=192.168.1.78;User ID=sa;Password=123' ).Northwind.dbo.Categories
2. add linkServer
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply