Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cleech
Starting Member
2 Posts |
 Posted - 2007-06-06 : 10:05:14
|
| Hello All:I'm new to this forum and new to the upgrade process for SQL2K5. I would like to get this upgrade moving. However, I running into a few problems. Right now I am attempting to use the Copy Database Wizard. SQL2K5 and SQL2K are installed on different servers. I made a copy of the tables for the database I am converting and this is the one I am trying to copy over. The process runs fine until it gets to the SQL Server Agent Job. It fails on this step and prompts to check the event log.Does anyone know what might cause this? Right now I'm looking for the easiest solution to test the data. Is the copy database wizard the best approach? Can anyone recommend another one? Maybe backup/restore.I used export from SQL2K to SQL2K5 and that worked, but it brought over the dbo prefixes. Any help is greatly appreciated. Or at least a shove in the right direction.Thanks,Cleech |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-06 : 10:19:02
|
| I prefer backup/restore since you don't have down time on source db. |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-06 : 10:24:54
|
also CDW is tricky to get working because it involves so many different technologies which have little to do with copying a database from one location to another: Agent, SSIS etc. If agent is not running on the target for instance, it will fail.use backup/restore.
elsasoft.org |
|
|
|
|
|
|
Using Copy Database Wizard to Upgrade to 2005