mssql2000

Hi
I am changing my server from mssq7 to sql2000
Do i need to upgrade my mssql7 databse to 2000.
or only i want to just attach db to 2000 server.
thanks.
Thanks
You can attach a 7 database to 2000. Another option is backup and restore. Just make sure you test
your applications...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"shif" <ns_0001@.hotmail.com> wrote in message
news:214DE35F-B234-4519-8754-E7D14B317A91@.microsoft.com...
> Hi
> I am changing my server from mssq7 to sql2000
> Do i need to upgrade my mssql7 databse to 2000.
> or only i want to just attach db to 2000 server.
> thanks.
> --
> Thanks

mssql2000

Hi
I am changing my server from mssq7 to sql2000
Do i need to upgrade my mssql7 databse to 2000.
or only i want to just attach db to 2000 server.
thanks.
--
ThanksYou can attach a 7 database to 2000. Another option is backup and restore. J
ust make sure you test
your applications...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"shif" <ns_0001@.hotmail.com> wrote in message
news:214DE35F-B234-4519-8754-E7D14B317A91@.microsoft.com...
> Hi
> I am changing my server from mssq7 to sql2000
> Do i need to upgrade my mssql7 databse to 2000.
> or only i want to just attach db to 2000 server.
> thanks.
> --
> Thanks

mssql2000

Hi
I am changing my server from mssq7 to sql2000
Do i need to upgrade my mssql7 databse to 2000.
or only i want to just attach db to 2000 server.
thanks.
--
ThanksYou can attach a 7 database to 2000. Another option is backup and restore. Just make sure you test
your applications...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"shif" <ns_0001@.hotmail.com> wrote in message
news:214DE35F-B234-4519-8754-E7D14B317A91@.microsoft.com...
> Hi
> I am changing my server from mssq7 to sql2000
> Do i need to upgrade my mssql7 databse to 2000.
> or only i want to just attach db to 2000 server.
> thanks.
> --
> Thanks

MSSQL to Oracle

hello,

I built my application using SQLClient classes and MSSQL database

i have another version of the database with Oracle, is changing to OracleClient classes the only change i have to do in order to run the program and the connection string?

Thanks

Nope...You also have to install the Oracle client, and give the accountthat your ASP.Net application is running under access to the directorythat the Oracle client is in.