October 10, 2011 at 12:49 pm
We are running SQL Server 2005 (SP3) on Windows 2003 Server. What is the best method to use to upgrade SQL Server 2005 Databases to SQL Server 2008. For example, is it best to use,
The SQL Server 2008 Installation Wizard
Are there any other method which may be used?
I have not transferred/copied databases since SQL Server 2000. Then, I used DTS Packages with Copy Database Task. What are some other methods to transfer/copy databases. I listed two I know of below:
Transfer Database Task in SSIS
Attach/Detach Method
To create an SSIS Package in SQL Server 2005 do you have to use Microsoft Visual Studio?
Thanks, Kevin
October 10, 2011 at 12:52 pm
Do you have a new SQL2008 server built?
If so backup\restore is usually best, the copy wizard would be my last choice.
---------------------------------------------------------------------
October 10, 2011 at 1:53 pm
Backup/restore is by far the most simple way to upgrade. Have you perused this particular forum for such an event?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
October 11, 2011 at 10:46 am
kevinsql7 (10/10/2011)
We are running SQL Server 2005 (SP3) on Windows 2003 Server. What is the best method to use to upgrade SQL Server 2005 Databases to SQL Server 2008. For example, is it best to use,The SQL Server 2008 Installation Wizard
Are there any other method which may be used?
I have not transferred/copied databases since SQL Server 2000. Then, I used DTS Packages with Copy Database Task. What are some other methods to transfer/copy databases. I listed two I know of below:
Transfer Database Task in SSIS
Attach/Detach Method
To create an SSIS Package in SQL Server 2005 do you have to use Microsoft Visual Studio?
Thanks, Kevin
IMHO and experience take source offline, copy files and attach is better. The other option is to detach the source database and copy the files then attach.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 12, 2011 at 5:34 pm
You neede to have BIDS installed to design SSIS packages though BIDS is also a part of Visual Studio family.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply