So, you’ve got a requirement to move or copy a table from one database to the other? Including data?
Use SELECT INTO.
For example, we have a database called “MyDatabase”
We also have another database – “MyNewDatabase”
MyDatabase contains the table “Customers” – with a bunch of data that we want to preserve.
You need to move this into MyNewDatabase?
Here is an example of the query:
[sql]SELECT * INTO MyNewDatabase.dbo.Customers
FROM MyDatabase.dbo.Customers[/sql]
You could of course predicate your query, include where clauses, select only a few columns etc.
Check out this post on W3Schools for more information, and how to use this in the same database (for temp. backups for example)