June 26, 2003 at 10:32 am
upgrade failed to copy data, all the structures where created. How do I transfer the data?
June 26, 2003 at 6:02 pm
DTS will do it pretty easily. I'd make sure you that you all the constraints and indexes, not just the tables. Probably are there, doesnt hurt to check. Might do just as well to drop everything and try again.
Andy
June 26, 2003 at 11:53 pm
1. Stop SQL 6.5 Services and copy mdf/ldf files . Rename files if you like
2.attach files to SQL 2000 using enterprise manager ie highlight databases >all tasks> attach
3. SQL 2000 will see it as SQL 6.5 DB , work O.K
4. Check Collation when running set up as it might cause issues with temp db
June 27, 2003 at 2:29 am
michaelr777
That method would work for moving SQL Server 7.0 databases to 2000, but SQL 6.5 does not share the same database file/device format as the others so it is not an option.
Colin
June 29, 2003 at 5:54 pm
Thanks for your help. I found the error logs There were some stored procedures that need to be change because they are not valid in 2000,after correcting it I am starting the opgrade over.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply