SQLTeam.com | Weblogs | Forums

Importing a complete table into another sql db


#1

I need to import a complete table, with data from one sql 2008 database into another. I looked at Import and Export function, but cant see how the table definitions can be imported.

Reg
Ash


#2

If the target database does not have the table defined, the wizard will build a CREATE TABLE statement.

I sometimes just pretend I'm an idiot (not far from the truth!) and click my way through to see what happens.


#3

yes, that worked fine, created the table

and the advice about clicking is priceless :+1:

Thank you