SSIS Import Wizard

[Mike Lewis]

Is this a new forum? If so, may I have the honour of posting the first question.

I am trying to migrate a non-SQL Server database to SQL Server 2005. The source database happens to be a Visual FoxPro DBC, but that's not really relevant. As far as SSIS is concerned, it is an OLE DB data source.

I am using the SSIS import wizard, and this has successfully imported all the tables, columns and data types. However, there seems to be no way of importing indexes or constraints.

Am I right that this is a limitation of the import wizard, or am I missing something?

It's not a big issue. I can always find other ways of doing the job. I just wanted to make sure I wasn't missing something obvious.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Catadmin]

Congratulations on being the first to post a genuine question!!

@=)

As far as the indexes and constraints go, usually SQL Server does not import those from other sources. It hasn't in the past, and I know of no reason this would have changed in SQL 2005.

Sorry.


Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

Correct SSIS and DTS don't pull in the indexes aned constraints. You'll need to create them manually.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

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

http://www.mrdenny.com

 

[Mike Lewis]

Thanks to both of you for your replies. This confirms what I had assumed. As I said earlier, it's not a problem. I can write code in Visual FoxPro to convert the indexes and constraints. I just wanted to check that it was necessary.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk