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.

Building on MSDE, but deploying in SQL 2000?

I'm new to SQL, so please forgive my rather primitive question...

If I build, for example, the Portal Starter Kit using MSDE, can I upload it to a host that supports SQL 2000 without having to make any special configurations? In other words, are MSDE and SQL 2000 interchangeable, for the most part?

Try these links first is the MSDE deployment toolkit and the second is SQL Server main site, try the first and if you run into problems, then download the evaluation edition it is good for 120 days and you can reinstall it. Hope this helps.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdedepl.asp
http://www.microsoft.com/sql

|||That does help. Thank you very much! :)|||I am glad I was able to be of assistance.