sql server dts: How can I import table indices for all the tables transferred from one db to Sql Server? -- sql server dts

How can I import table indices for all the tables transferred from one db to Sql Server?

Sami
3/14/2005 1:13:52 PM

sql server dts: Hello,
I was successfully able to import all the tables from a SQLBase db to MSSQL.
Now i would also like to import all the indexes for the tables.
How can I do that?

--
Regards,
Sami

[Remove Numbers from e-mail address to use it]

Re: How can I import table indices for all the tables transferred from one db to Sql Server?

Allan Mitchell
3/14/2005 7:15:35 PM

The only way I can think of would be if SQLBase has metadata tables from
which you can query for the indexes. You could query them and create
the CREATE INDEX statements required on SQL Server and then run them.
There is no part of Native DTS that will do this for you though.

Allan

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.