SQLServer -> Access

[fragglerock]

I have a need (expect to see it on dailywtf soon!) to export a database OUT of SQLServer INTO Access. However when I use the DTS export wizard it gets tables and data but loses the join information.

Is there a way of keeping the structure as well as the tables/data?

Thanks
Fr

 

[r937]

join information? what do you mean by this?

r937.com | rudy.ca

 

[fragglerock]

Sorry had my inarticulate hat on!

I mean the relationships between tables, Primary keys, Foreign keys, that sort of thing.

Thanks for asking for clarification and not just moving on to the next thread!

 

[r937]

you're saying the DTS wizard doesn't handle that?

well, i don't have it here to test it, but if it can't do the job, then i would create the DDL manually and use DTS only for the data

r937.com | rudy.ca

 

[ptheriault]

I think it's an option in DTS to copy PK and FK as well.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[fragglerock]

Well I may be being stupid but I cannot see how to get it to copy the keys... certainly no "Copy keys?" checkbox!

Could I ask you to have a quick look to see how you would do it?

Thanks...