Re: converting MS SQL to MySQL

2003-02-10 Thread Barry C. Hawkins
in google and php.nt - and so far coming up a blank - can u > help put me on the right track. > > Scott > > > - Original Message - > From: "Barry C. Hawkins" <[EMAIL PROTECTED]> > To: "Hawk" <[EMAIL PROTECTED]> > Cc: <[EMAIL

Re: converting MS SQL to MySQL

2003-02-10 Thread Barry C . Hawkins
Hawk, While your script is fairly straightforward in terms of SQL syntax, Transact-SQL and MySQL's dialect of SQL are different enough that you will have to modify some things. Here's a link to the CREATE INDEX syntax page of the online MySQL manual: http://www.mysql.com/doc/en/CREATE_INDEX.h

Re: converting MS SQL to MySQL

2003-02-09 Thread Veysel Harun Sahin
Take look at http://www.mysql.com/doc/en/CREATE_TABLE.html [EMAIL PROTECTED] wrote: Hi, I am new to SQL. I am attempting to create a database that was created in MS SQL to MySQL. The below SQL statements works with MS SQL. I am executing the following: CREATE TABLE 'Accounting'(

Re: converting MS SQL to MySQL

2003-02-09 Thread mysql-list-bot
Hawk <[EMAIL PROTECTED]>, Do you think the following links may help? * http://www.mysql.com/doc/en/Using_mSQL_tools.html * http://www.mysql.com/doc/en/Using_InnoDB_tables.html This was an automated response to your email 'converting MS SQL to MySQL'. Final search keyword used to

Re: converting MS SQL to MySQL

2003-02-09 Thread Bob Hall
On Thu, Feb 06, 2003 at 10:03:18AM -0500, Hawk wrote: > > > Hi, > > I am new to SQL. I am attempting to create a database that was created in > MS SQL to MySQL. The below SQL statements works with MS SQL. MS SQL could refer to either Jet SQL or SQL Server SQL, but the SQL below is obviously

Re: converting MS SQL to MySQL

2003-02-09 Thread Insanely Great
The best way is to import data from MS SQL Server to MySQL. SQLyog at http://www.webyog.com/sqlyog/download.html has a DTS like ODBC Wizard. Try it out and all you data will be imported. Insane - Original Message - From: "Hawk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday,

RE: converting MS SQL to MySQL

2003-02-09 Thread Hawk
At 04:13 PM 2/7/2003 +, you wrote: We sell a data converter for this purpose check out www.bpenet.net I'm not concern about transferring the data. I was having problems creating the indexes. thanks for the reply... Michael Johnson Managing Director Humphrey Consulting Limited BPEnet T

RE: converting MS SQL to MySQL

2003-02-09 Thread Cal Evans
check the docs at www.mysql.com for the CORRECT command to create indexes. =C= * Cal Evans * Stay plugged into your audience. * http://www.christianperformer.com -Original Message- From: Hawk [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 9:03 AM To: [EMAIL PROTECTED] Subje

Re: converting MS SQL to MySQL

2003-02-09 Thread mysql-list
Hi Hawk <[EMAIL PROTECTED]>, I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Using_mSQL_tools.html * http://www.mysql.com/doc/en/Using_InnoDB_tables.html This was an automated response t