RE: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-05 Thread Rick Faircloth
g MSSQL Scripts into MySQL Scripts > > That sounds like what I need! > > Thanks, Gerald! > > Rick > > > -Original Message- > > From: Gerald Guido [mailto:[EMAIL PROTECTED] > > Sent: Monday, February 04, 2008 5:48 PM > > To: CF-Talk >

RE: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-05 Thread Rick Faircloth
That's exactly what I'm in the process of doing. Thanks, Kevin! Rick > -Original Message- > From: Kevin Aebig [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 05, 2008 1:37 PM > To: CF-Talk > Subject: RE: OT: Translating MSSQL Scripts into MySQL Scripts >

RE: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-05 Thread Kevin Aebig
Chris Montgomery [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 6:28 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > Rick Faircloth said the following on 2/4/2008 12:53 PM: > > Can anyone recommend a program that will translate &g

RE: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Rick Faircloth
: Monday, February 04, 2008 6:28 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > Rick Faircloth said the following on 2/4/2008 12:53 PM: > > Can anyone recommend a program that will translate > > MSSQL scripts into MySQL scripts? I foun

RE: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Rick Faircloth
That sounds like what I need! Thanks, Gerald! Rick > -Original Message- > From: Gerald Guido [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 5:48 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > MSSQL Expres

Re: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Chris Montgomery
Rick Faircloth said the following on 2/4/2008 12:53 PM: > Can anyone recommend a program that will translate > MSSQL scripts into MySQL scripts? I found some on > Google. couldn't find a way to do it on mysql.com. > > Before I try a program to do this, I thought I'd > get some recommendations fro

Re: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Gerald Guido
; as a go-between? I don't want to invest much, because > this is a one-time operation. I can do it manually. > > Rick > > > -Original Message- > > From: Todd Rafferty [mailto:[EMAIL PROTECTED] > > Sent: Monday, February 04, 2008 3:16 PM > > T

Re: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Todd Rafferty
Go go fingers! Good luck! On Feb 4, 2008 3:48 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > I can get the data from MSSQL with Navicat. > What I want is something to run or translate the > MSSQL table creation scripts the data vendor sent. > > Is there some sort of free or inexpensive MSSQL-ty

RE: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Rick Faircloth
nvest much, because this is a one-time operation. I can do it manually. Rick > -Original Message- > From: Todd Rafferty [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 3:16 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > >

Re: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Todd Rafferty
You won't be able to use "scripts" as Gerald mentions. This assumes you've got SQL Server running somewhere and you setup an ODBC connection to it and the wizard sucks all that information across and converts it appropriately. Does a great job of it. So, I guess this isn't what you're after, sorr

RE: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Rick Faircloth
I saw that, but I wasn't totally sure that meant it would translate or be able to use MSSQL scripts. Thanks, Rick > -Original Message- > From: Todd Rafferty [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 2:57 PM > To: CF-Talk > Subject: Re: OT: Trans

Re: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Gerald Guido
version? > > Rick > > > -Original Message- > > From: Todd Rafferty [mailto:[EMAIL PROTECTED] > > Sent: Monday, February 04, 2008 2:37 PM > > To: CF-Talk > > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > > > Poke me off list if

Re: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Todd Rafferty
Did you look at the feature matrix? http://www.webyog.com/en/sqlyog_feature_matrix.php "Wizard Driven Migration Toolkit" falls under Enterprise. I have enterprise and it's cheap enough ($97) and does the job and then some - I'm quite happy and it's worth the money. On Feb 4, 2008 2:48 PM, Rick F

RE: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Rick Faircloth
Todd... Will the Community Version of Sqlyog perform the script conversion or does it take the Enterprise version? Rick > -Original Message- > From: Todd Rafferty [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 2:37 PM > To: CF-Talk > Subject: Re: OT: Tr

RE: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Rick Faircloth
Thanks, Todd! Rick > -Original Message- > From: Todd Rafferty [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 2:37 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > Poke me off list if you need assistance with Sqlyog.

Re: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Todd Rafferty
Poke me off list if you need assistance with Sqlyog. On Feb 4, 2008 2:28 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Thanks, Todd... I'll check it out! > > I've got Navicat, which I've used to administer > MySQL since version 3, but I'm not sure if it will > perform this task. At least I hav

RE: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Rick Faircloth
mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 2:17 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > I use SQLyog ( http://www.webyog.com/en/ ). Just used it recently to > convert a database that was in SQL Server Ent and created

RE: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Rick Faircloth
Guido [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 2:11 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > I am not sure what you are asking. Do you want to import a MSSQL database to > Mysql? > > Or do you want to get somethin

Re: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Todd Rafferty
I use SQLyog ( http://www.webyog.com/en/ ). Just used it recently to convert a database that was in SQL Server Ent and created MySQL tables, etc. Very easy and simple to use migration tool. ~Todd On Feb 4, 2008 1:53 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > > Can anyone recommend a prog

Re: OT: Translating MSSQL Scripts into MySQL Scripts

2008-02-04 Thread Gerald Guido
I am not sure what you are asking. Do you want to import a MSSQL database to Mysql? Or do you want to get something that will translate the MS's T-SQL dialect to MySQL? On Feb 4, 2008 1:53 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Can anyone recommend a program that will translate > MSSQL