SQL Server - MS SQL 2000 - Asked By Erwin Bercx on 18-Jul-14 12:40 PM

I'm using MySQL, but want to upgrade to MS SQL 2000 server.
Is it possible to import my current databases into MS SQL?

...I just checked my SQL Server 2000 Enterprise Edition and didn't see a specific reference to MySQL.  
Doubtful that it would work properly...

I'm not that familiar with MySQL, but I am sure you can view the table and index  and column data types so that SQL server scripts can be created from these. Table data can be exported as flatfiles (comma-delimited textfiles) for easy import into your new SQL Server database. Finally, if you can connect to MySQL via ODBC, it's a simple matter to use the SQL Server Data Transformation Services (DTS) wizard to move everything from the MySQL to SQL Server. Since I don't believe MySQL supports stored procedures, that's one last item you won't have to worry about.

I'm running currently a website with 4000+ visits a day. The reason why i want to upgrade to MSSQL is because the MySQL software crashes every 4 hours or so. Users gets the screen message "unable to open the database". The software is still in beta testing for windows machines, but i can't keep continueing running this sql server.
Since the site runs on PHP files, i need to modify all the files to communicate with MSSQL. All files shows lines like
"mysql_pconnect($dbhost, $dbuname, $dbpass);"
What's the variable to connect to the MSSQL server in this case?