Large MySQL SQL File -> ASP.NET Database

[Jonathan Wood]

Greetings,

I have backed up a MySQL database from a PHP site. This backup is in the
form of a large (55MB) SQL file.

Can anyone tell me how I can convert it to an ASP.NET database?

The file is too large for cut and paste and it appears the SQL content is
not fully compatible with Microsoft SQL.

Thanks.

Jonathan

 

[Norman Yuan]

MySQL and MS SQL Server are two different database server product. A backup
from one cannot ne restored on the other. If you have a database on a MYSQL
Server, you do not need to "CONVERT" to a database used by ASP.NET, you can
use MySQL as data source for an ASP.NET application. However, you may be
able to use SQL Server's DTS to import data (and even database structure)
from your MySQL database into a SQL Server database, with or without
modification, depending on the database structure in MySQL.

Keep in mind, database server is fairly complicated server software, no one
on the market (SQL Server, MySQL, Oracle, DB2, FireBird, ...) are
"compatible" to the other, if by compatible, you mean to simply copy/back up
from one and paste/restore to the other.

 

[Jonathan Wood]

Norman,

MySQL and MS SQL Server are two different database server product. A
backup from one cannot ne restored on the other.

I understand that, but surely this can't be the first time it came up. If I
understood the two versions of SQL script, it would probably take me a
couple of hours to write a converter. Surely, someone else already did this.

use MySQL as data source for an ASP.NET application. However, you may be
able to use SQL Server's DTS to import data (and even database structure)
from your MySQL database into a SQL Server database, with or without
modification, depending on the database structure in MySQL.

So far, I'm just going for SQL Express and have downloaded SQL Server
Management Studio Express. Let me guess: "DTS" is a tool available with MS
SQL proper?

Keep in mind, database server is fairly complicated server software, no
one on the market (SQL Server, MySQL, Oracle, DB2, FireBird, ...) are
"compatible" to the other, if by compatible, you mean to simply copy/back
up from one and paste/restore to the other.

It's a frickin' mess is what it is. Thought I'd try me some ASP.NET. So that
means HTML, XHTML, XML, ASP.NET, C#, ASP.NET CLR, SQL (MySQL), SQL (MS SQL),
and a heap more just to try and get some simple Web applications going.

Thanks.

Jonathan

 

[William \(Bill\) Vaughn]

AFAIK there is no such thing as an "ASP.NET" database. ASP.NET is an
application paradigm--a way of writing browser-UI-based applications. The
real question is, can a database engine like MySQL function adequately from
such an application.
Now if you wanted to move the data in the MySQL database to be accessible by
another (like SQL Server Express) a "large" 55MB database would entail using
SQL Server Integration Services, DTS or BCP (all do about the same thing
with different interfaces) to transport the data. The SQL queries you use to
access it would also require conversion (not a simple job in of itself).
Incidentally, 55MB (or 550MB) is a relatively small database in SQL Server
terms--miniscule actually.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

 

[Jonathan Wood]

William,

AFAIK there is no such thing as an "ASP.NET" database. ASP.NET is an
application paradigm--a way of writing browser-UI-based applications. The
real question is, can a database engine like MySQL function adequately
from such an application.

My apologies for sloppy terminology.

Now if you wanted to move the data in the MySQL database to be accessible
by another (like SQL Server Express) a "large" 55MB database would entail
using SQL Server Integration Services, DTS or BCP (all do about the same
thing with different interfaces) to transport the data. The SQL queries
you use to access it would also require conversion (not a simple job in of
itself).

Okay, so basically it involves some technologies I don't understand, and the
query would still need to be converted. Perfect.

Incidentally, 55MB (or 550MB) is a relatively small database in SQL Server
terms--miniscule actually.

Yes, yes--that really wasn't the point of my post. It's large enough that I
don't want to type it in. And, given the long line lengths, it's long enough
to bring SQL Server Management Studio Express pretty much to it's knees.

Jonathan

 

[William \(Bill\) Vaughn]

Perhaps, but I would invest in the Developer Edition (about $35 US) which
has all the tools you'll ever need.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

 

[Jonathan Wood]

Developer Edition of ... ?

Jonathan

Perhaps, but I would invest in the Developer Edition (about $35 US) which
has all the tools you'll ever need.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

 

[William Vaughn]

SQL Server.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------