Copying database objects using SMO

Question

Hi,

I am trying to copy table, indexes, keys, views and functions in SQL 2005. Any idea how I could do so using SqlServer.Management.Smo?

The user will specify the object names to be copied and the new names to be given to the objects.

I need to do it in the most efficient way

Thanks :)

Answer 1

Not the answer per se, but you might find http://www.codeplex.com/OpenDBiff/ helpful