MySQL vs Access vs SQL Server

Post Reply

Page <123 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
VBScript Members Profile Find Members Posts Senior Member Joined: 14 July 2004 Location: United Kingdom Status: Offline Points: 219	Post Options Post Reply Quote VBScript Report Post Thanks(0) Quote Reply Posted: 27 February 2006 at 5:24pm
	I am writing an application (EXE) to convery any MS Access Database to mySQL I hope to release in a few days. Unfortunatly, I have not had much luck with MSSQL Edited by VBScript - 27 February 2006 at 7:53pm
	James Trillian - M

Meson Members Profile Find Members Posts Newbie Joined: 03 June 2003 Location: United States Status: Offline Points: 33	Post Options Post Reply Quote Meson Report Post Thanks(0) Quote Reply Posted: 28 February 2006 at 8:44am
	Access's export to ODBC dtabase features does a nice job of transering data between Access and MySQL. THe only bug that nees to be fixed is the boolean values as mySQL doesn't understand them, and some field size modifications.

RadioActiveLamb Members Profile Find Members Posts Groupie Joined: 29 December 2005 Location: United States Status: Offline Points: 171	Post Options Post Reply Quote RadioActiveLamb Report Post Thanks(0) Quote Reply Posted: 01 March 2006 at 12:14am
	Data transformation from MSSQL to MSAccess is very straight-forward. Once in MSAccess format, use your up-coming tool to transfer to MySQL. Since it is a one-time thing, I don't think too many people would be upset performing a 2-step process.

xeerex Members Profile Find Members Posts Senior Member Joined: 19 November 2002 Location: United States Status: Offline Points: 601	Post Options Post Reply Quote xeerex Report Post Thanks(0) Quote Reply Posted: 07 March 2006 at 1:17pm
	Any success on the conversion tool from Access to MySQL yet?
	Need Hosting, Domains, Dedicated Servers? web design \| pc support \| training \| podcasts \| video production

VBScript Members Profile Find Members Posts Senior Member Joined: 14 July 2004 Location: United Kingdom Status: Offline Points: 219	Post Options Post Reply Quote VBScript Report Post Thanks(0) Quote Reply Posted: 07 March 2006 at 3:21pm
	I hope to have it released within a week. It has taken quite a bit of research because I have never used mySQL before.
	James Trillian - M

xeerex Members Profile Find Members Posts Senior Member Joined: 19 November 2002 Location: United States Status: Offline Points: 601	Post Options Post Reply Quote xeerex Report Post Thanks(0) Quote Reply Posted: 07 March 2006 at 4:05pm
	Thanks -- I've only played with mySQL so I'm in the same boat.
	Need Hosting, Domains, Dedicated Servers? web design \| pc support \| training \| podcasts \| video production

VBScript Members Profile Find Members Posts Senior Member Joined: 14 July 2004 Location: United Kingdom Status: Offline Points: 219	Post Options Post Reply Quote VBScript Report Post Thanks(0) Quote Reply Posted: 08 March 2006 at 7:57pm
	I have made quite a lot of progress since yesterday. I will be able to release on saturday or even late this friday if all goes to plan! Watch this space I will let you know A.S.A.P when it is ready to download. xeerex, thanks for the interest in the tool im creating
	James Trillian - M

xeerex Members Profile Find Members Posts Senior Member Joined: 19 November 2002 Location: United States Status: Offline Points: 601	Post Options Post Reply Quote xeerex Report Post Thanks(0) Quote Reply Posted: 09 March 2006 at 1:20pm
	============= xeerex, thanks for the interest in the tool im creating ============= No problem at all. I've got a migration to do for a WWG board and this could help me out tremendously. If you need bandwidth for the download or anything like that, let me know. I can help you out in that way - or even a small paypal donation.
	Need Hosting, Domains, Dedicated Servers? web design \| pc support \| training \| podcasts \| video production

Post Reply	Page <123 >

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.