September 28, 2011 at 8:18 am
We are going to upgrade from SQL 2005 to SQL 2008. My manager has mentioned that one of the upgrade tasks is to run validation scripts. Previously I've upgraded SQL 2000 databases to SQL 2005 but I'm not sure what validation scripts is my manager referring to. Could someone please explain what my manager means by "running validation scripts"?
September 28, 2011 at 9:19 am
Can only speculate that he meant Upgrade Advisor: http://www.microsoft.com/download/en/details.aspx?id=11455
But certainly only your Manager knows for sure 🙂
October 4, 2011 at 12:54 am
The validation of scripts examines the syntax of each Transact-SQL statement and returns any errors without compiling or executing the statement.
To validate the syntax of your query from the toolbar :
--> Open the query in the Transact-SQL editor.
--> On the Transact-SQL Editor toolbar, click Validate SQL Syntax.
Running of the validation scripts means it will run temporary on SSMS and it will not modify anythg to our main database and your manager said you to do so because he first wanted to confirm wheather the ongoing dbs are running properly on SQL SERVER 2008 as compare to SQL SERVER 2005.
After you write a script or query, you can validate the Transact-SQL syntax before you execute the script or query. If your query is succesfully runned on Validate SQL syntax that dos not mean that we have been done with our modifications , for permanent changes we have to run query in normal query window as we normally do.
During the validation, the query is checked for correct Transact-SQL syntax. If an error is found, it appears on the Results tab of the results pane and in the Error List window. If no errors are found, the message "Command completed successfully." appears.
I have already done with the same and i did not get any issues , you can go ahead and one more thing we can even have both SQL server 2005 and 2008 on same machine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply