Transfer data from one database to another database

by

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

More Related Contents:

  1. Efficiently convert rows to columns in sql server
  2. T-SQL split string
  3. How can I get column names from a table in SQL Server?
  4. Conditional WHERE clause in SQL Server
  5. How can I select the first day of a month in SQL?
  6. Multi-statement Table Valued Function vs Inline Table Valued Function
  7. GROUP BY to combine/concat a column [duplicate]
  8. Select statement to find duplicates on certain fields
  9. Copy data into another table
  10. Using a Variable in OPENROWSET Query
  11. How to find current transaction level?
  12. How do I see active SQL Server connections?
  13. EXISTS vs JOIN and use of EXISTS clause
  14. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  15. Why is a UDF so much slower than a subquery?
  16. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  17. Alternate of lead lag function in SQL Server 2008
  18. UNIX_TIMESTAMP in SQL Server
  19. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  20. SQL Server SELECT LAST N Rows
  21. The transaction log for the database is full
  22. Generate random int value from 3 to 6
  23. Add emoji / emoticon to SQL Server table
  24. Select SQL Server database size
  25. Backup a single table with its data from a database in sql server 2008
  26. COALESCE Function in TSQL
  27. Cannot Resolve Collation Conflict
  28. Try_Convert for SQL Server 2008 R2
  29. Display next event date
  30. Sql query for tree table

Leave a Comment