access to sql migration
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=17925
Printed Date: 29 March 2026 at 3:11am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: access to sql migration
Posted By: netsonic
Subject: access to sql migration
Date Posted: 13 January 2006 at 5:02pm
|
Hi all; i am upgrading my db...But everytime i get errors from DTS IMPORT/EXPORT tool...i ve tried many ways but everytime i got error on some parts. is there any conversion tool for that issue?if not please show me a way in which order i must convert this.which tables first?which scripts first (creating tables,indexes,relationships,storep procedures etc...) Thank you |
Replies:
Posted By: michael
Date Posted: 13 January 2006 at 8:14pm
|
SP and Views don't matter really. When you use DTS you need to transfer all tables that have PK's first and then the FK Tables. Try to display all tables in a Diagram with their relations and migrate the one that has no FK first and so on. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: netsonic
Date Posted: 14 January 2006 at 12:23am
|
thanks micheal the access db is corrupted a bit for example (i am not sure the problem may be about indexes) the DTS tool try to copy the 3000. row but it give error i ve looked the total row count is 2700...so no row like 3000 how can i repair such problems? and also the system works without copying relations...is it dangeraous to use it without relations? thank you. |
Posted By: dpyers
Date Posted: 14 January 2006 at 2:33am
|
You should always do a compact and repair on the access db first.
------------- 
Lead me not into temptation... I know the short cut, follow me. |