December 27, 2007 at 2:16 pm
Im about to do full conversion from SQL 2000.
Im reading this http://www.sqlservercentral.com/articles/Administration/2987/
My plan is as follows:
I have ran the advisor on all SQL 2000 machines.
Will copy all logins from SQL 2000 to SQL 2005
Backup database and restore to SQL 2005
Set mode to 90
Run update statistics (dbname) (do i need to do WITH FULLSCAN)
(When would i do the rebuild of indexes before the update statistics).
What is the Full Text Indexes and how can i confirm if there are these.
Any steps missed?
January 3, 2008 at 7:05 am
Just couple of questions.
How sure are you that you do not have any embedded SQL's in the applications that might not work in 2005?
Did you by any chance test all applications in a test environment in 2005?
-Roy
January 3, 2008 at 7:49 am
What is embedded SQL.
Most of the developers will be testing their databases and applications.
Major ERP system is from outside companies that provide upgrades for the SQL 2005.
We will be testing everything.
January 3, 2008 at 8:01 am
Embedded SQLs are SQLs written in the Application code itself. Usually everyone writes stored proc and calls them from application but some programmers like to code the sqls in the application itself. This is difficult to trace other than keeping an eye on the profiler.
We have a third part app that has embedded SQL and they are not doing an Upgrade to 2005. So we reverse engineered their app and build our own with only SPs.
-Roy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply