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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net