Export table data from one SQL Server to another

by

Try this:

  1. create your table on the target server using your scripts from the Script Table As / Create Script step

  2. on the target server, you can then issue a T-SQL statement:

    INSERT INTO dbo.YourTableNameHere
   SELECT *
   FROM [SourceServer].[SourceDatabase].dbo.YourTableNameHere

This should work just fine.

More Related Contents:

  1. Add a column with a default value to an existing table in SQL Server
  2. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  3. How can I do an UPDATE statement with JOIN in SQL Server?
  4. The multi-part identifier could not be bound
  5. How to return multiple values in one column (T-SQL)?
  6. Fastest way to update 120 Million records
  7. Can a Check constraint relate to another table?
  8. Is it possible to select sql server data using column ordinal position
  9. How to find current transaction level?
  10. How to insert multiple records and get the identity value?
  11. How to Replace Multiple Characters in SQL?
  12. How can a LEFT OUTER JOIN return more records than exist in the left table?
  13. EXISTS vs JOIN and use of EXISTS clause
  14. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  15. Dynamic SQL to generate column names?
  16. SQL comma-separated row with Group By clause
  17. How to copy a huge table data into another table in SQL Server
  18. Column name or number of supplied values does not match table definition
  19. How to split string using delimiter char using T-SQL?
  20. SQL Server PIVOT perhaps?
  21. How to find consecutive rows based on the value of a column?
  22. Should I use SQL_Variant data type?
  23. SQL server select distinct rows using most recent value only
  24. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  25. How to escape square brackets inside square brackets for field name
  26. What is the internal representation of datetime in sql server?
  27. Eliminate and reduce overlapping date ranges
  28. Is there a quick way to check if ANY column is NULL?
  29. Why do SQL Server Scalar-valued functions get slower?
  30. SQL query for parent-child chain

Leave a Comment