Upsizing big DB

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Takhir Members Profile Find Members Posts Newbie Joined: 01 March 2003 Location: Belgium Status: Offline Points: 26	Post Options Post Reply Quote Takhir Report Post Thanks(0) Quote Reply Topic: Upsizing big DB 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

ljamal Members Profile Find Members Posts Mod Builder Group Joined: 16 April 2003 Status: Offline Points: 888	Post Options Post Reply Quote ljamal Report Post Thanks(0) Quote Reply 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 L. Jamal Inc : Web/ Print Design and ASP Programming

Takhir Members Profile Find Members Posts Newbie Joined: 01 March 2003 Location: Belgium Status: Offline Points: 26	Post Options Post Reply Quote Takhir Report Post Thanks(0) Quote Reply Posted: 26 May 2003 at 3:43am
	this does not work, problem with the keys.

ljamal Members Profile Find Members Posts Mod Builder Group Joined: 16 April 2003 Status: Offline Points: 888	Post Options Post Reply Quote ljamal Report Post Thanks(0) Quote Reply 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 L. Jamal Inc : Web/ Print Design and ASP Programming

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.