Migration from MSSQL 6.5 to MS Access 2000

Last Post 09 Mar 2004 09:12 PM by vasum. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
vasum
New Member
New Member

--
09 Mar 2004 02:39 AM
Hi Everybody,

We have planned to Migrate MSSQL 6.5 to MS Access 2000 based on Business Request.

Pls. advise us how to go about. You input is much appreciated.

tks in advance,
vasum
vasum
New Member
New Member

--
09 Mar 2004 09:12 PM
Hi rm,

thanks for your reply. What about if we use SQL 2000 DTS (Export & Import) by connecting to MSSQL 6.5 as source and Destination as ms access.

Will it be helpful?. Any problem we face by doing this?.

tks in advance,
vasum
bluespud
New Member
New Member

--
06 Apr 2004 10:35 PM
I have done this but am having serious performance trouble, it is like the dbms is not using the indices, despite having them being rebuilt once the db came accross to 2000. See my thread asking this same question.


Acceptable Use Policy
---