October 30, 2008 at 7:38 pm
Hello,
I have developed a database using SQL Server 2005 Express Edition and Management Studio Express for a client that recently informed me they have not yet rolled over to SQL Server 2005, but are still using 2000. I am unfamiliar with 2000, and am wondering what issues I may have in importing stored procedures, user-defined functions, and views from 2005 to 2000. A second part of the question is, when the finally do upgrade to 2005, can I expect limited issues when I roll them over?
Thanks,
Robin
October 30, 2008 at 8:36 pm
Two things. You will need to script everytyhing from your SQL Server 2005 Express database, ensuring you do so for SQL Server 2000. This shouldn't be a problem unless you used any new features or capabilites that were introduced in SQL Server 2005, such as CTE's, windowed functions, pivot/unpivot, etc.
As long as you also used ANSI standard joins in queries, etc you shouldn't have any problems moving back to SQL Server 2005 when they make the jump.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply