How to tell SQL Server Export Wizard to also create indexes of new table in destination?

Question

I am working with SQL Server 2008 R2.

I have a source database and a destination database. In source database I have a table named rule_attribute which have 2 indexes. This table does not exist in destination database.

I ran the SQL Server Export Wizard to copy this table from source database to destination database.

The wizard ran successfully and the table was copied to destination database along with data. But the 2 indexes on this table were not created.

Is there any reason why indexes were not created?

Is there any setting which allows to create indexes as part of wizard?

Thanks

Answer 1

The Import/Export wizard doesn't allow copying indexes, but if you use the Database Scripting tool it will allow you to add indexes in the scripts.