how to use MSSQL SERVER 2000 with the database management

Dec 9, 2008 at 8:43 AM
I just have the SQL SERVER 2000, how can I use this project?
Coordinator
Dec 9, 2008 at 9:32 PM
We've never tested this with SQL 2000, but SQL Server Express 2005 and 2008 are both free to download.
Dec 10, 2008 at 7:21 AM
I haven't tried SQL 2000, but i got Oxite working with SQL Server 2005 (not Express). I assume you can get Oxite working with SQL 2000 in the same way. These are the steps i took:

-Make a copy of the Oxite_Database.mdf file using the "Microsoft SQL Server Data Publishing Wizard". You need to have SQL 2005 Express installed to do this.
-Create an empty SQL 2005/2000 database.
-Run the created .sql file from step 1 on your new database.
-Update the connectionstring in your Oxite web.config file to point to the new database.

Good luck!