how to insert a table with structure and data into another database? [duplicate]

This question already has开发者_Go百科 answers here: Closed 11 years ago.

Possible Duplicate:

How to insert rows with structure from one table to another table?

how to insert whole table with structure and data into another database?

---

What database are you working with?

MS SQL has some good data migration tools in the management studio. There's a wizard to select objects and data and it creates a SQL script to create everything and add the data.