I am using MySQL as website database.
I am going to migrate to .Net technology.I wonder How could I convert MYSQL DB to MSSQL 2005 so that I could use my databse informations.

you can use MySQL with .Net or you can export from MySQL and import into MS SQL.

How depends on what tools you have available.

Yeah! As commented by Chrishirst, you can stick with your MySQL database with your .Net applications. The good thing is for commerical usage, the price of MySQL should be much lower than that of MS SQL.

Which surely must be a serious consideration. Why people blindly go to MS products that cost an arm and a leg when you can do exactly the same thing for next to nothing in comparison is a sure lesson in the brainwashing and marketing of Microsoft over the market.

But who am I to slate a multi billion $$ company who as on countless accounts been taken to court for attempting to monopolise the computer market and deny us other chaps any chance of existence. How bleak an industry it would be if it was all MS.

Ibbo

I am going to reply to your comments

Originally Posted by MyOpinion

you can stick with your MySQL database with your .Net applications. The good thing is for commerical usage, the price of MySQL should be much lower than that of MS SQL.

Some webhosting based on linux plans offer Mysql with low price as some of windows webhosting offer MSSQL with even lower price than Mysql.
Some webhosting companies offer service including 50 GB per month beside $20/year , but in function their services are very poor and you won't even use 5 percent of your bandwidth.since you can't make conclusion with only price of some webhostings.
MS SQL 2005 is one of .NET technology basis.

Originally Posted by ibbo

Which surely must be a serious consideration. Why people blindly go to MS products

which surely must be a serious consideration is that you can't prescribe the same database for every one without knowing their requirements. The foundation of programming won't allow you to blindly use ay technology. the programmer is only one who take the final decision.

Originally Posted by ibbo

when you can do exactly the same thing for next to nothing in comparison .

search any desireable internet search websites about this topic "MSSQL2005 vs Mysql" it will be so help full to be familiar with their comparision

Originally Posted by ibbo

... is a sure lesson in the brainwashing and marketing of Microsoft over the market.
But who am I to slate a multi billion $$ company who as on countless accounts been taken to court for attempting to monopolise the computer market and deny us other chaps any chance of existence. How bleak an industry it would be if it was all MS.
Ibbo

I do not think the topic tiltle is about Microsoft product VS open soruce. It's just about introduce a convertor program for migration from php to .NET.

This is not simple discussion. it's not only about trade & business, it's even about Policy.

thanks for your reply ibbo and waiting to hear from you.
best regards,

[quote]
The foundation of programming won't allow you to blindly use any technology
[/qoute]

I beg to differ.

Lets take ADOBD for example. This is a mighty fine Database API and all i need do is provide it with a db type username and password. Then no matter what database architecture is underneath I dont care nor need to care. This is the beauty of programming, encapsulation and the need not to need to know what lies beneath. ALL one needs is an API and your off.

Why would you want to migrate to .NET and from what? I automagically assume with you using MySql to start with that your already running with php. This is a good solution already and I am wondering whats made you jump ship?

MSSQL2005 vs Mysql

Why would I do that. It does not have to be MS SQL or MySql, it could be oracle it could be Postgres it could be Sybase. Each and every one of them will claim to better than the other and in some areas they do outdo each other.

My rant above is that MySql is an open source solution and has no liscencing fees behind it. And while MS SQL may have slkackened its liscences of late it is still an MS product and requires MS windows to run on. This again cost yet more in fees.

So finally to answer your intial question of how or a good method to convert your DB.

Im sure your inserts will be the same in any sql language so a dump of your mysql DB would put you half way there.

All you need to do after that is tidy up your creates and modify the types and key definitions to make them happy with MS SQL.

Good luck

The foundation of programming won't allow you to blindly use any technology

I would argue with this also

The foundation of good programming will allow you to use ANY technology available, Only the syntax will vary

With SQL, provided that you use standard ANSII code, the most widely used being SQL-92, most versions of servers will support SQL-1999 and in the newer releases SQL-2003 is supported, You should have no problems porting the code from server to server.

The main issue between MS SQL and MySQL will be if you use SPs (Stored Procedures) which are only supported in MySQL from Ver5 on.

Although I'm not agree with Antitrust and do not find it usefull for Commerce and Science -in this special case IT- But I need a company which could provide me special suports while I need it. meanwhile microsoft products are in the first grade. You will travel with the vehicle, which it's support centers is available and active.

Finally thanks for your reply to the thread.
I have searched the web and have found database convertor which could convert most of websites to eachother automatically.any one who needs this software tell me.