vijayleads
MIS
Hello,
I am trying to migrate data from an access database to sqlserver 2000 using DTS. I am able to create the same tables just like in the source(access) but the relationships and joins are getting lost.
for example if i have two tables, customer and customer_detail in access. there is a join on cust_id on these tables. I am using to DTS to move these two tables to sqlserver2000. I get 2 tables with the same name but they have no join on them.
So my question is do i have to manually create the joins or is there a way to migrate all the tables with the joins between them intact.
Any help will be highly appreciated.
thanks
vijay
I am trying to migrate data from an access database to sqlserver 2000 using DTS. I am able to create the same tables just like in the source(access) but the relationships and joins are getting lost.
for example if i have two tables, customer and customer_detail in access. there is a join on cust_id on these tables. I am using to DTS to move these two tables to sqlserver2000. I get 2 tables with the same name but they have no join on them.
So my question is do i have to manually create the joins or is there a way to migrate all the tables with the joins between them intact.
Any help will be highly appreciated.
thanks
vijay