Web Wiz Forums - Upsizing big DB

Print Page | Close Window

Upsizing big DB

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3004
Printed Date: 01 April 2026 at 8:47am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Upsizing big DB

Posted By: Takhir
Subject: Upsizing big DB
Date Posted: 25 May 2003 at 4:11am

what most rapid way for the passage on SQL server? I tried upsizing in accesse but this very slowly, and in me base is more than 30 megas-byte

Replies:

Posted By: ljamal
Date Posted: 25 May 2003 at 9:01am

The easiest way is probably using the forum to create the tables in SQL and then using SQL Import/ Export system in import the data from your Access files.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming

Posted By: Takhir
Date Posted: 26 May 2003 at 3:43am

this does not work, problem with the keys.

Posted By: ljamal
Date Posted: 26 May 2003 at 8:39am

You may have to remove the primary keys on the SQL tables and import the tables in an order which does not cause foreign key conflicts.

Maybe you can search to board to see if anyone else has done this or maybe there is a MOD. This seems like it should be a common enough for some to have scripted it.

-------------
L. Jamal Walton

http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming