CirquedeSQLeil (3/16/2010)
Grant Fritchey (3/16/2010)
What about a simple backup and restore? Or are you trying to build some sort of deployment mechanism?Backup and restore would be my first inclination for users databases. However, if they are moving from SQL 2K to SQL 2K8, there are some other nuances to be addressed (dts, ssis, jobs) that would be different.
Even if I was moving between 2K & 2K8, I'd do a backup and restore, but, as you say, stuff before and stuff after. Without knowing what's really desired here, it's all just guess work.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning