MS SQL / MY SQL

[Brett Schulte]

Are MS SQL and MY SQL databases interchangeable?

 

[Thomas A. Rowe]

What do you mean by interchangeable?

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[Brett]

What do you mean by interchangeable?

Can a database built on MS SQL work on my web servers MY SQL?

Brett

 

[Thomas A. Rowe]

You would have to export and then import the data from one to the other, and
field types may be slightly different. The syntax of the queries and update
statement may need to be change as well.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[Kevin Spencer]

The only things the 2 databases have in common are:

1. They are both database servers
2. They both have "SQL" (acronym for "Structured Query Language") in their
names.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Big things are made up of
lots of little things.