2005 TO 2000 Possible?

[LocaSimon]

i have Databases with 2005 SQL i want to Use these databses on 2000 MSSQL there is anyway to do it? or atleast anyway to transfare all chracters and accoutns and guilds to 2000 ???!!!
Thank YOu!

[MentaL]

[chumpywumpy]

If you have full SQL2005 and not just express you can right-click the database and go Tasks->Generate scripts. Here you can create a script that will recreate your database. Check through the advanced options as you need to tell it to include your data, not just the schema, and include any triggers and other stuff you want added as well as setting the compatibility level to SQL2000. In 2000 create the empty databases and then run the scripts in them.

If not use can restore the databases normally in 2000, right-click and use the Import Data option to slurp up the data from the 2005 express server<->server.

Make sure you have backups just in case ;)

[LocaSimon]

I Downloaded the MSSQL Of Your Links i Guess.. i have MSSQL Studio Express and i have SQL Server Config manager And these Stuff :|