September 11, 2008 at 12:04 pm
I have one database file in SQLExpress , i want to convert my data tables to SQL2000 Database.
Is it possible to Convert or not.??
please , reply me if it is possible.
-Abhishek
September 11, 2008 at 12:22 pm
Can't remember the specifics and maybe someone else does. If you take the mdf and reattach it to the 2K engine it should work. Then under option in the database properties change the compatibility level. Is this going 2K express to 2k standard or 2k5 to 2k?
September 11, 2008 at 2:39 pm
You can't directly convert a database from 2005 to 2000.
What you can do is create a parallel database, with the same tables, code, etc., and migrate the same data into it. That would get the right end result. Depending on the size and complexity of the database, that can take a while to do.
You'll need to check, as you move objects from 2005 to 2000, that you don't have any code that can't run in 2000, or any or any columns of data types that 2000 didn't have (like varchar(max) or XML).
SSIS can help you with the data moves.
I have to ask: Why the backwards migration?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 15, 2008 at 1:28 pm
along the same lines as other posters, you can consider creating a new 2k database, then use RedGate SQL Data Compare (you can use the trial for free) to copy the data from your 2k5 express database to the new DB, or you can BCP the data... or use SSIS as suggested above
I am assuming you have a SQL Server 2005 Express database and you want to essentially replace it for a SQL Server 2000 database... right? Is it because of a licensing issue?
If it's not a licensing issue then I would also wonder why you would want to downgrade to 2000. If you happen to have a 2k5 license, then you can consider changing the compatibility level from 9.0 to 8.0
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply