How do I go from my WAMP environment to using MSSQL?
2 answers
- Download mssql express http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx
- Check out one of the larger database abstraction layers like PDO http://www.php.net/pdo
- Refactoring your code to use the database abstraction layer
- You may need to rewrite mysql specific things to "standard" SQL
+4
a source to share
Start with Sql Server running. If you are using an old copy of Sql Server (pre-2005) you need to make sure ntwdblib.dll is present in your System32 directory and removed from your PHP dll directory (ntwdblib.dll is installed using corporate tools, so you may have to install them and to your PHP block). After Mssql query is correct, start searching where Mssql differs from MySql in the code.
A few tips:
- ntwdblib doesn't accept long lines (I think it's 4k limited, but don't quote me on that). You should use Stored Procs if you are trying to process a string longer than 4k.
- Try using Sql Server 2005 if you can (see above), ntwdblib.dll is ancient and has many problems.
- The PHP site is your friend for mssql .
+3
a source to share