Tuesday, February 14, 2012

Building with SQL server, but deploying with MSDE

I am building a site, I'd like to use SQL server, but once the site is finished it i for a organisation who do a lot of community voluntary work. So to keep the costs down I plan to install on their server a copy of MSDE as the datasource.

I know it is a simple question, but if I build the site using SQL server and deploy onto MSDE will the site still work?::I know it is a simple question, but if I build the site using SQL server and deploy onto MSDE
::will the site still work?

This depends on what you do in SqlServer.

Using Sql Server: works.
Using Full Text Search extension: No luck.

And any additional service - out of luck, too.

But if you just use what MSDE can deliber (core SQL), then - yes, it will still work.

No comments:

Post a Comment