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
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
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.
yes, that worked fine, created the table
and the advice about clicking is priceless
Thank you