{"id":830,"date":"2015-07-07T19:52:53","date_gmt":"2015-07-07T18:52:53","guid":{"rendered":"http:\/\/dotnetsql.info\/net-sql\/?p=830"},"modified":"2015-08-13T12:18:11","modified_gmt":"2015-08-13T11:18:11","slug":"how-do-you-get-data-from-a-database-on-another-server","status":"publish","type":"post","link":"http:\/\/dotnetsql.info\/net-sql\/index.php\/how-do-you-get-data-from-a-database-on-another-server\/","title":{"rendered":"How do you get data from a database on another server?"},"content":{"rendered":"

If you want to import data only through a T-SQL query, then use the OPENDATASOURCE function. To repeatedly get data from another server, create a linked server and then use the OPENQUERY function or use 4-part naming. If you are not using T-SQL, then it is better to use the import\/export wizard, and you can save it as a SSIS package for future use.<\/p>\n

Thanks \u00a0for reading \u00a0this \u00a0article,<\/strong><\/p>\n

Next steps :<\/strong><\/p>\n

1.\u00a0 Share this with your colleagues because Sharing\u00a0 is Learning<\/strong><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 2. Comment below if you need any assistance<\/strong><\/p>\n

Powered by CodeReview – Let’s make it Better!<\/a><\/strong><\/em><\/p>\n

Share this:<\/h3>