Migrating Access to SQL for HC database

Anyone tried to get these instructions to work?

http://hostingcontroller.com/english/support/kb/HCKB-Article133.html

I¬ve tried everything and I¬m finding that when you import the Access database into SQL, it does not import ¬AutoNumber¬ aka ¬Identity¬ for particular Table Columns and also does not set the Primary and Foreign Keys correctly.

Now if you are going to tell me that this document was before they started bundling the hcver2002 SQL database I tried that as well and did not have any success, but what about those who are using Access and want to migrate to SQL while retaining the data thats in their Access database?

It should work even though you were using MS Access for quite a long time. I will suggest you to first upsize your Access database locally on SQL Server then move your HC SQL database backup to remote SQL Server machine. If your issue is still there then please send your server access directly to support dept. by mail. They will debug this issue for you.

Is the performance increase that great? How much can one expect?

Thank you

KM

We have locally tested it and it works efficiently.

Sigh.. As always the response does not answer the question correctly...

Well that is something intangible I can not exactly measure the performance. You already know SQL Server has much more benefits than MS Access.

Ahh the documentation wasn¬t clear that you must use the UPSIZING WIZARD in Access. Thus the problem. Instead of Importing from SQL 2000 Enterprise Manager you must open the database in Access and use the Upsizing Wizard. You might want to update the Knowledgebase documentation explain this fact.

FYI this article is for fresh installation of HC not for existing HC running with MS Access. Anyway we will update it for existing HC installation with Access database. Thanx for your advise.