Tuesday, April 26, 2011

How to Restore SQL Server 2008 to SQL Server 2005

This is the only way I found we can downgrade database versions.

Creating Scripts to Move SQL Server 2008 Database to SQL Server 2005
These steps show you how to generate the necessary scripts.
  • Use the scripting wizard in SQL Server 2008 to script data as well as schemas into SQL Server 2005 compatibility mode.
  • Run "Generate SQL Server Scripts" wizard in SQL Server Management Studio (once Object Explorer is connected to the appropriate instance) by right clicking on database and selecting "Tasks –> Generate Scripts."
  • Click "Script all objects in selected database" & then click "Next."
  • Change script options: Specifically, set "Script for Server Version" to "SQL Server 2005" and set "Script Data" to "True". (SQL Server 2000 is also supported.) If you are putting the database on a new instance for the first time, make sure the "Script Database Create" option is set to "True." Click "Next" when you are happy with options.
  • Finish the wizard.
After creating the file with these changes, you can run the script in SQL Server 2005 Management Studio to recreate the database in your development environment. You can now test data against SQL Server 2008 and SQL Server 2005.


Sources :


Posted by Chamila at 6:15 PM 0 comments
Labels:
| More

Sys.WebForms.PageRequestManagerParserErrorException error - ASP.NET Ajax 1.0

Error Message : 
Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled.
Details: Error parsing near '
<!DOCTYPE html PUB'.

Have you ever got these kind of error when you are doing an Async postback using AJAX.NET .Actually If you’ve seen this error, you’ve probably already spent some time to resolve it. Anyway The solution mentioned below is worked for me. 

1) Make sure this in is your web.config
   <httpModules>
      <add name=”ScriptModule” type=”System.Web.Handlers.ScriptModule, System.Web.Extensions,               Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35?/>
   </httpModules>

2) Add this to the to the Page declaration if you’re experiencing some page refresh bugs
   enableEventValidation=”false”


Source : http://weblogs.asp.net/albertpascual/archive/2008/04/22/how-to-fix-sys-webforms-pagerequestmanagerparsererrorexception-in-ajax-1-0.aspx


If you’ve found alternatives to this problem or our suggested solution isn’t working for you, please feel free to comment below.

Posted by Chamila at 5:54 PM 2 comments
Labels:
| More