SQL Server 2000 and SQL Server 2005

[LouisC4]

Hello I am fairly new using VS.NET 2.0. I have installed Visual Studio 2005 with SQL Server 2005 on my computer. I am currently working on a website project that requires a simple database. My hosting company supports VS.NET 2.0 with SQL Server 2000 only, for now.

My question is this: If I create a web project in VS 2005 using SQL Server 2005 locally (in my computer), can I upload my web project on to my hosting provider's server who's running SQL Server 2000? or do I need to do some adjustments in order for it to run in SQL Server 2000?

Thank you,

Louis

 

[gmmastros]

If you have a SQL 2000 database, you cannot attach it to a SQL 2005 instance. Your only option would be to completely script the database (table structures and data) and then run the scripts on your 2000 database. This is REALLY ugly, so you should avoid that if possible.

My recommendation would be to download MSDE 2000. Install it on your computer. You can use the SQL Server Management Studio to manage a SQL 2000 database. Then, when you want to upload the database to your hosting company, simply detach the SQL 2000 database and upload it.

http://www.microsoft.com/downloads/...D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[LouisC4]

Thanks George,

I did download the MSDE 2000, when I try to install it, it gives me this error:

[A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. ...]

I've tried putting this line on the setup.ini file:

SETUP SAPWD="MyStrongPasswordHere"

and also

SETUP SAPWD=MyStronPasswordHere

but it does not work.

Any suggestions?

Thanks again

 

[gmmastros]

Everything I've read suggests that the way you specify the password (in your first example) should work.

You could try creating a setup.ini file in the same folder as the setup.exe. In the INI file, you can specify the password. It's worth a shot.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[LouisC4]

I got it to install!!!

What I did is to run the setup from the command prompt this way:

setup SAPWD=MyPassword SecurityMode=SQL

Thanks,

Louis