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?

Don't use MySQL but... - Asked By Robbe Morris on 30-Apr-01 06:09 PM

...I just checked my SQL Server 2000 Enterprise Edition and didn't see a specific reference to MySQL.  

Doubtful that it would work properly...

MS SQL 2000 - Asked By Peter Bromberg on 30-Apr-01 06:37 PM

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.
Asked By Erwin Bercx on 18-Jul-14 12:41 PM
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?