some quick advice if possible on MSDE

[hog]

I currently have a trial version of an application released to users which connects to an Access2002 database backend. As I am still developing the application I have been investigating the possibility of moving it over to a SQL Server database using MSDE as I am reading that it is more efficient.

 

I have little knowledge of SQL Server or MSDE so was wondering could someone just clarify a few points if possible.

 

If I create a version of my Access2002 database as a SQL Server database using the server explorer within .NET do all I need to do is this:

 

1. copy the database to a machine which has MDSE running on it

 

2. modify my code so that it uses the SQL namespace objects rather than OLEDB

 

3. does the PC that will have the database and MSDE installed need to have the server service running? I am aware that there is a limit of having a maximum of ten user connecting to a PC with the server service running, to ensure Windows 2000 server is used for greater number of users. Therefore I assume the MSDE can operate without the server service running???

 

all help gratefully recieved...

 

 

 

:)

[Robby]

1. This can be done using SQL Scripts or those scripts can be run from .NET.

 

2. You don't have to, but it is recommended.

 

3. The service needs to run.

[Derek Stone]

The "Server" service is largely unrelated to Microsoft SQL Server. It does not need to be enabled/started for SQL Server to work. The rest of your upgrade path seems right.

[Robby]

oh, I thought the service needs to run.

[wyrd]

*scratches* If I don't have my service running I'm not able to connect to any of my MSDE databases.. :confused:

[jfackler]

I can't access msde databases without mssql service running.

I wonder if he is referring to IIS?

 

I'm also a little unclear regarding the statement:

 

"create a version of my Access2002 database as a SQL Server database using the server explorer"

 

I can manipulate the database after it's open, however, it sounds as if he intends to create the database

via server explorer after simple copying a .mdb file to the machine running his msde.

 

Am I confused or what.

[Robby]

Hog means the Server Explorer in your VS IDE.

[Derek Stone]

need to have the server service running?

The "Server" service is largely unrelated to Microsoft SQL Server.

 

"Server" is the name of a Windows service that is involved with RPC. That's what I am referring to. Since people are less than explicit on this board half the time I have no desire to assume he's referring to something else, if in fact he is.

[hog]

OKey dokey :-)

 

Yes I mean to create the database within the Visual Studio .Net Server Explorer

 

Yes I intend to have the MSDE service running in order to allow access to the SQL database

 

I was asking do I need the Windows Server service running as well as the MSDE in order for users to connect to my database or do I just need the MSDE running?

 

Derek you have understood me correct. Thanks to you all for you comments :-)