Win2k3 Web Edition

[mooncat]

I am kinda confused over this issue however I know that the web edition can't have sql server installed.I know that I need to use sql express 2005 for this.

Is it embedded in the OS or I have to install it manually.The reason I am asking is I have to setup a Japanese server and it`s live.It has sharepoint running and the asp2.0 conf has some kinda obscure sql2005 express link.But can`t seem to find any admin interface.Hard enought to decypher as it is.

Also we have made asp2.0 site with a DB made in SQL2000 and am wondering if we are gonna have trouble moving onto this platform with SQL2005express.

Any input or potential stumbling points to look out for would really be appreciated.

Thanks in advance

Dave MCP

 

[mrdenny]

SQL express is not included with the OS. It would need to have been installed seperatly. When you install Sharepoint server it will install a copy of MSDE 2000 on the server.

There is no admin interface for MSDE 2000 or SQL Express 2005 by default. I beleive that Microsoft has released a SQL Express admin interface that can be downloaded. Or you'll need to find a third part admin interface.

The other option is to use the command line interface that comes with each platform. MSDE uses ISQL and SQL Express 2005 uses SQLCMD.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mooncat]

Thanks man I appreciate that. I know windows server but really not well versed on sql.

I am not really wanting to run sharepoint.it`s only a platform for a webinterafce driven by a DB.

Basically all it has to do it is run.

Also you think there will be any issues about moving a DB made in sql2000 to 2005 express?Again I don`t know much about the new product.

Thanks anyway for your helpful repsonse.

David

 

[mrdenny]

Moving from one version of SQL to another all depends on if the vendor supports it, and if the code runs fine.

99% of SQL 2000 code will run fine on SQL 2005.

You'll want to test everything in dev first to be sure.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mooncat]

Great thanks for your help.

Greatly appreciated and thanks for taking the time to answer.

I will try it and see how it runs.

David

 

[mooncat]

Actually I have one more question. SQL isn`t really my strong point and I have been coerced into doing this.

However I am trying to figure out how to import a DB made in 2000 into sql2005 express.I thought I might be able to back up or import it that way somehow.

I installed the express server2005 and the managment tools.

I am gonna try figure it out but any help would save me from screwing it up big time.

Thanks guys

David MCP

 

[Catadmin]

Most of the datatypes in SQL 2000 are supported in SQL 2005, so restoring the database itself to SQL 2k5 Express shouldn't be much of an issue. Still, as Denny mentioned in another recent post (thread962-1192618), it wouldn't be a bad idea to run your DB through the Upgrade Wizard just to triple check for any immediately (and devestating) compatibility issues.



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.

 

[mooncat]

Thanks for your reply.I already checked that post.

However express won`t let me import the Database from 2000.I get an error stating the path is not found even when I try to restore it.

I tried creating a new DB and overwriting the .mdf and ldf files and then try to restore it.None of it works really.

I am gonna keep reading and trying.

Thanks again

David MCP

 

[mrdenny]

You will probably need to specify the MOVE paramater when restoring the database for each logical file in the database. When you install 2005 the file paths are different and the paths that SQL is trying to restore to doen't exist (unless you create them you self). I would recommend moving the files into the correct folders (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data by default; I use E:\MSSQL\MSSQL.1\MSSQL\Data to keep it shorter).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mooncat]

Thanks MrDenny again.I will give it a go

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com