Re: Moving from MSSQL to mySQL
here: http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html unless you are migrating from windows to linux though I wouldn't recommend doing this. SQL Server is the far superior solution, easier to use, easier to manage, better client tools, better backup options, generally more reliable. This opinion is based on 10 years hosting both in a shared hosting environment by the way, hundreds of databases for hundreds of customers. -- Russ Michaels www.cfmldeveloper.com - Supporting the CF community since 1999 FREE ColdFusion/Railo hosting for developers. blog: www.michaels.me.uk ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving from MSSQL to mySQL
Check out Intelligent Solutions - we have utility software from them to do Access and mySQL. -- mac jordan On 1 Dec 2010, at 18:07, Monique Boea wrote: > > Hello All. > > Is there a utility that will allow me to copy the tables and structure from > an MS SQL database to a mySQL one? > > Thanks > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339691 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving from MSSQL to mySQL
It's not up to me :( The company is switching because the hosting company convinced the previous developer that it was a good idea. On Wed, Dec 1, 2010 at 1:26 PM, Russ Michaels wrote: > > here: > http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html > > unless you are migrating from windows to linux though I wouldn't recommend > doing this. SQL Server is the far superior solution, easier to use, easier > to manage, better client tools, better backup options, generally more > reliable. > This opinion is based on 10 years hosting both in a shared hosting > environment by the way, hundreds of databases for hundreds of customers. > > > > > -- > Russ Michaels > www.cfmldeveloper.com - Supporting the CF community since 1999 > FREE ColdFusion/Railo hosting for developers. > > blog: www.michaels.me.uk > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving from MSSQL to mySQL
What's the link? there are a million Intelligent Solutions out there :) On Wed, Dec 1, 2010 at 1:39 PM, mac.jordan wrote: > > Check out Intelligent Solutions - we have utility software from them to do > Access and mySQL. > > -- > mac jordan > > > On 1 Dec 2010, at 18:07, Monique Boea wrote: > > > > > Hello All. > > > > Is there a utility that will allow me to copy the tables and structure > from > > an MS SQL database to a mySQL one? > > > > Thanks > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving from MSSQL to mySQL
No idea - not at my desktop. Google for intelligent converters mysql mssql - that should find them. On Wed, Dec 1, 2010 at 7:44 PM, Monique Boea wrote: > > What's the link? > > there are a million Intelligent Solutions out there :) > > On Wed, Dec 1, 2010 at 1:39 PM, mac.jordan wrote: > > > > > Check out Intelligent Solutions - we have utility software from them to > do > > Access and mySQL. > > > > -- > > mac jordan > > > > > > On 1 Dec 2010, at 18:07, Monique Boea wrote: > > > > > > > > Hello All. > > > > > > Is there a utility that will allow me to copy the tables and structure > > from > > > an MS SQL database to a mySQL one? > > > > > > Thanks > > > > > > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339703 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving from MSSQL to mySQL
While I have great respect for Russ, I respectfully and completely disagree with just about everything he said there. Not that you even asked for the lists opinion on what DB solution is better, but I just wanted to make it known that there are plenty of folks out here with huge amounts of respect for MySQL. Facebook runs on MySQL, so it can't be all bad, right? ;) -Jordan On 12/01/2010 11:43 AM, Monique Boea wrote: > > It's not up to me :( The company is switching because the hosting company > convinced the previous developer that it was a good idea. > > > On Wed, Dec 1, 2010 at 1:26 PM, Russ Michaels wrote: > >> >> here: >> http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html >> >> unless you are migrating from windows to linux though I wouldn't recommend >> doing this. SQL Server is the far superior solution, easier to use, easier >> to manage, better client tools, better backup options, generally more >> reliable. >> This opinion is based on 10 years hosting both in a shared hosting >> environment by the way, hundreds of databases for hundreds of customers. >> >> >> >> >> -- >> Russ Michaels >> www.cfmldeveloper.com - Supporting the CF community since 1999 >> FREE ColdFusion/Railo hosting for developers. >> >> blog: www.michaels.me.uk >> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving from MSSQL to mySQL
Facebook == Pure Evil. It *is* all bad. :-) On Wed, Dec 1, 2010 at 2:09 PM, Jordan Michaels wrote: > > Facebook runs on MySQL, so it can't be all bad, right? ;) > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339705 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving from MSSQL to mySQL
There's also SQLYog Enterprise. It has a conversion tool for this as well. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog On 12/1/2010 2:48 PM, mac jordan wrote: > No idea - not at my desktop. Google for intelligent converters mysql mssql > - that should find them. > > On Wed, Dec 1, 2010 at 7:44 PM, Monique Boea wrote: > >> What's the link? >> >> there are a million Intelligent Solutions out there :) >> >> On Wed, Dec 1, 2010 at 1:39 PM, mac.jordan wrote: >> >>> Check out Intelligent Solutions - we have utility software from them to >> do >>> Access and mySQL. >>> >>> -- >>> mac jordan >>> >>> >>> On 1 Dec 2010, at 18:07, Monique Boea wrote: >>> Hello All. Is there a utility that will allow me to copy the tables and structure >>> from an MS SQL database to a mySQL one? Thanks >>> >> > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving from MSSQL to mySQL
I didn't say it was BAd Jordan, I would not be stupid enough to say that as it is clearly a very popular and well used RDBMS. However most people just use the free edition of MySQL because it is free and are not even aware that there is a free edition of SQL server too called SQL Server express. I would encourage anyone to try out both rather than take mine or anyone else word for it. Just to backup my previous comment though, in many years of running both, we have very rarely had any SQL Server issues, however I cannot say the same about MySQL. We have have numerous customers with corrupted MySQL databases, this has never happened on any MSSQL server. A single mysql database can also easily cane the server and cause 100% cpu usage and cause it to become unresponsive, never had such an issue on MSSQL. So take form that what you will. > On Wed, Dec 1, 2010 at 7:44 PM, Monique Boea > wrote: > > > >> What's the link? > >> > >> there are a million Intelligent Solutions out there :) > >> > >> On Wed, Dec 1, 2010 at 1:39 PM, mac.jordan > wrote: > >> > >>> Check out Intelligent Solutions - we have utility software from them to > >> do > >>> Access and mySQL. > >>> > >>> -- > >>> mac jordan > >>> > >>> > >>> On 1 Dec 2010, at 18:07, Monique Boea wrote: > >>> > Hello All. > > Is there a utility that will allow me to copy the tables and structure > >>> from > an MS SQL database to a mySQL one? > > Thanks > > > > >>> > >> > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving from MSSQL to mySQL
>Hello All. > >Is there a utility that will allow me to copy the tables and structure from >an MS SQL database to a mySQL one? > >Thanks I use this product - works flawlessly. When moving large amounts of data, just be sure to go into settings and use NO skin. It bogs it down. Otherwise it works beauifully...maintaining PK's, FK's, indexes, etc etc. http://dbconvert.com/convert-mssql-to-mysql-sync.php Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339708 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Moving from MSSQL to mySQL
I second that, have used it numerous of times when converting from MSSQL to MySQL, and it works just about perfect. Sebastiaan = So long and thanx 4 all the fish ==> Onlinebase.nl > To: cf-talk@houseoffusion.com > Subject: Re: Moving from MSSQL to mySQL > Date: Wed, 1 Dec 2010 16:30:32 -0500 > From: w...@wtomlinson.com > > > >Hello All. > > > >Is there a utility that will allow me to copy the tables and structure from > >an MS SQL database to a mySQL one? > > > >Thanks > > I use this product - works flawlessly. When moving large amounts of data, > just be sure to go into settings and use NO skin. It bogs it down. Otherwise > it works beauifully...maintaining PK's, FK's, indexes, etc etc. > > http://dbconvert.com/convert-mssql-to-mysql-sync.php > > Will > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339727 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm