The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Re: Converting MySQL to SQL Server 2000?

Originally posted by Sparkie Is it possible? I'm hosted with a site that uses SQL Server 2000, but my scripts are all MySQL documents. Is there some way to set them up so they'll work in SQL Server 2000?

Help!!

Sparkie

I assume this means the scripts she uses to access the data? So =X¥®µ§= was on the right track, or am I taking this the wrong way?

Originally posted by Defender1Leave it to MS to develop such a stupid way to escape a quote.

AFAIK, that's the more standard way to escape quotes.

- Matt ** Ignore old signature for now... **
Dr.BB - Highly optimized to be 2-3x faster than the "Big 3." "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR

Originally posted by voostindBe careful saying things like 'this is the more standard way', because it tells us about where you're coming from, and it ain't always good... (To name VB, for example) 8-D

never used VB before. be careful saying things like that.

Originally posted by scoatesI'm sure that '' is the ANSI SQL Specific way to escape a quote. Some DBs allow \' (which, IMHO is better, and much more readable), but the standard, is, in fact, two quote characters together ('').

yep, that's what i thought. i think every DB supports '' since it's the SQL standard. for example, in the Postgre manual it says Postgre "also supports escaping with a backslash (\\')," which implies that '' is the standard way of doing it.

Converting your data from MySQL to SQL Server 2000 will be two-fold...

First you will need to get the data out of MySQL. The easiest way to do this is to use something like PHPMyAdmin and save the data as CSV files.

After that you will have to massage the data so that you won't have errors in the import.

The second step requires you to build your tables in SQL Server. You can use the basic table definations for your MySQL scripts as a start but there is no such thing as AUTO-INCREMENT fields (instead you have identity fields) and indices are defined differently. You will have to make these modifications.

Finally you will use SQL Server's tools to load the CSV files into the proper tables.