Difference between SQL server Compact 4.0 and SQL server

Question

What is the difference between App_Data  SQL server Compact 4.0 local database and SQL server database.Which one is the better option when developing ASP.NET web application.