Create destination table disabled SQL 2005

[gdeleon]

Hi:
Im am using the Import/Export wizard to copy tables from one database to another.
When I select the destination table, if it already exists the wizard disables the "create destination table" option.
¿Do you know Why?

Thank you,

Gustavo de Leon

 

[mrdenny]

Because the table already exists. If it tried to create the table the package would fail.

If you need the table empty use the delete exists data option.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[gdeleon]

Thank you Denny for your response.

The "delete rows in destination table" option is not enough to me: sometimes the destination table is old and the source one has new or modified attributes. So, in order to be sure I have the same structure, I need to delete and re-create the table.
As a matter of fact, that option is present in SQL 2000 import/export wizard and it works ok.
Furthermore, the option "Drop and recreate destination table" is present but also disabled in SQL 2005, so I think they have the intention to enable it in certain circumstances.

Of course, I still can delete the table first "by hand", but I wonder why they disabled the option.

I also miss the "copy objects" option, which has disappeared.

Regards,
Gustavo

 

[mrdenny]

The copy objects has been removed from that wizzard. Right click on the database, all tasks, copy database.

Or build an SSIS package which drops the table, then copies over the object. Then run the SSIS package instead of the wizzard.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com