October 8, 2007 at 2:11 pm
When i try to copy database from SQL server 2000 to 2005 using the MAnagement Studio of 2005, the wiard shows.."Copy Success". But when i check the datatbase in 2005 , i see none....!!!!All i see is system tables...!!!
Any suggestions...????
October 10, 2007 at 1:28 pm
May be u r comying table into a different database and looking ur results in some other database.
October 10, 2007 at 1:32 pm
You response "I could be looking in different datatabse is soo funny".
However, i have made all kind of checking..to make sure i am not making any mistake in copieing/checking right database. Any other thoughts...???
October 10, 2007 at 3:02 pm
why r u copying, why can't u just take backup of that database and restore to ur SQL2005 instant, that way u will not miss anything. Tables or views or procs. Or ur just trying to copy few tables not alll the tables
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply