Need help exporting a database from Sql 2000 Exterprise and Import it to Sql 2005 using Sql Developer.
I have tried to do a detach - copy mdf & ldf to new syatem and then do an attach - This doesn't seem to work
Also tried backup on 2000 and then Resore on 2005. This doe not seem to work.
Source system is 64bit and destination system is 32bit
Not 100% certain but the problem is probably with the 64bit to 32bit conversion problem. The binary files are probably incompatible.
Try and straight db copy Management Studio by right clicking the on the database | Tasks | Copy DB. Make sure not use the detach and re-attach method.
No comments:
Post a Comment