I will be moving my website from my local dev server to the live environment soon. I've been using SQL 2000 to develop, but the live DB is SQL 2005. My app uses exclusively stored procedures for all data access.
What suprises are in store for me when I migrate the site?!
Thanks, Jamie
If you don't have any DTS, scheduled tasks to worry about. Then the migration is very straight forward, personally, I have not encounter any problems. What I did is to script the entire DB's table def, indexes, sp, udf. Then run it once on 2005.
This article contains step-by-step process:http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/
No comments:
Post a Comment