Re: Moving from MSSQL to mySQL

2010-12-01 Thread Russ Michaels
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 m

Re: Moving from MSSQL to mySQL

2010-12-01 Thread mac.jordan
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? > >

Re: Moving from MSSQL to mySQL

2010-12-01 Thread Monique Boea
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 mig

Re: Moving from MSSQL to mySQL

2010-12-01 Thread Monique Boea
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: >

Re: Moving from MSSQL to mySQL

2010-12-01 Thread mac jordan
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: > > > >

Re: Moving from MSSQL to mySQL

2010-12-01 Thread Jordan Michaels
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 res

Re: Moving from MSSQL to mySQL

2010-12-01 Thread Matt Quackenbush
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.amazo

Re: Moving from MSSQL to mySQL

2010-12-01 Thread Matthew Williams
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

Re: Moving from MSSQL to mySQL

2010-12-01 Thread Russ Michaels
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

Re: Moving from MSSQL to mySQL

2010-12-01 Thread Will Tomlinson
>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 work

RE: Moving from MSSQL to mySQL

2010-12-02 Thread Sebastiaan GMC van Dijk
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 myS