Content migration

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
yandr Members Profile Find Members Posts Groupie Joined: 10 March 2009 Status: Offline Points: 106	Post Options Post Reply Quote yandr Report Post Thanks(0) Quote Reply Topic: Content migration Posted: 19 March 2009 at 12:43pm
	Do you have any adviceon migrating the content from an Access database to SQL server and vice versa? An automated import tool would be nice.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 19 March 2009 at 1:34pm
	Microsoft have tools for doing this. There is the Upsize Wizard built into Access or you can use the Microsoft SQL Server Migration Assistant. However both will create extra timestamp fields that need to be removed, amd yje Migration Assistant will create extra constants that also need to be removed after the migration is complete. You should also run the database optimisation tool as well on the migrated SQL Server database which will be available from the web wiz forums download page leter today.
	Web Wiz Forums Hosting ASP.NET Web Hosting

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.