Copy table to a different database on a different SQL Server

by

Yes. add a linked server entry, and use select into using the four part db object naming convention.

Example:

SELECT * INTO targetTable 
FROM [sourceserver].[sourcedatabase].[dbo].[sourceTable]

More Related Contents:

  1. SQL Server: Examples of PIVOTing String data
  2. Simulation of CONNECT BY PRIOR of Oracle in SQL Server
  3. What is “with (nolock)” in SQL Server?
  4. Using a if condition in an insert SQL Server
  5. Altering a column: null to not null
  6. Incorrect syntax near ‘GO’
  7. Bulk Insert Partially Quoted CSV File in SQL Server
  8. How to programmatically create an ODBC Linked Table to a SQL Server View and have it be editable?
  9. Is it possible to set a timeout for a SQL query on Microsoft SQL Server?
  10. Best way to store time (hh:mm) in a database
  11. Using variable in SQL LIKE statement
  12. How do I select last 5 rows in a table without sorting?
  13. Why does a parameterized query produces vastly slower query plan vs non-parameterized query
  14. displaying multiple records by using resultset
  15. SELECT INTO a table variable in T-SQL
  16. How to display two digits after decimal point in SQL Server
  17. Joining tables from different servers
  18. Is it possible to use user defined aggregates (clr) with window functions (over)?
  19. “No backupset selected to be restored” SQL Server 2012
  20. Calculate Time Difference Between Two Rows
  21. comma delimited list as a single string, T-SQL [duplicate]
  22. How to get only numeric column values?
  23. Using SSDT, how do I resolve SQL71561 errors when I have a view that references objects in a different database?
  24. SQL Server error “Implicit conversion of because the collation of the value is unresolved due to a collation conflict.”
  25. Undesired rounding of DateTime in SQL Server
  26. How to choose the clustered index in SQL Server?
  27. How can I show the table structure in SQL Server query?
  28. INSERT INTO @TABLE EXEC @query with SQL Server 2000
  29. How to insert a record with only default values?
  30. Cannot delete rows from a temporal history table

Leave a Comment