MarkusB (12/19/2011)
I would try using SSIS to import the SQL 2000 database.I can't try myself right now, but I would think that's your best bet.
Hey MarkusB!
If I am not mistaken SSIS wasn't there in SQL 2000, I believe you are referring to DTS.
That actually gives me an idea to move the 2000 DB to 2005 / 2008 instance (DTS -> SSIS) then move the new database to 2012. Any ideas ?!?!
Sorry I cannot try this myself as I do not have 2000 instance 🙁