Transfer Data one server to another

Question

I want use insert into sql query sqlserver2008 like this insert into server2 table select * from server1 table but is not use

Vipan Sharma · Answer

INSERT INTO dbo. YourTableNameHere SELECT * FROM [SourceServer].[SourceDatabase].dbo.YourTableNameHere try this. It's work for me.

Nikhil Sangani · Answer

I think you have to use Linked servers option of sql server2008 for transfer data from one server to another. I hope this link will useful for you. https://msdn.microsoft.com/en-in/library/ff772782.aspx

Munesh Sharma · Answer

http://okayguru.blogspot.co.uk/2012/03/copy-one-database-to-another-database.html There are several ways to do this below are two options: Option 1 - Right click on the database you want to copy Choose 'Tasks' > 'Generate scripts' 'Select specific database objects' Check 'Tables' Mark 'Save to new query window' Click 'Advanced' Set 'Types of data to script' to 'Schema and data' Next Next You can now run the generated query on the new database. Option 2 Right click on the database you want to copy 'Tasks' > 'Export Data' Next Next Choose the database to copy the tables to Mark 'Copy data from one or more tables or views' Choose the tables you want to copy Finish