Installing MS SQL 7 engine on client machine

[Gabby]

I am currently developing a client-server system using visual basic and sql
server. I need to know how i can install SQL server on the client machine
without having to install all components (such as enterprise manager) and
still be able to backup, restore and configure the database on the client
machine. I only need the core sql sever components. How can i still configure
the database with minimal installed components?

The reason for having sql server on both client and server is that the server
is remote and connection can be lost between them. The client machine is
obviously smaller in memory so having all the extra components installed
will slow it down.

Can any one help?

Thanks

[kevin knudson]

First you would need a license at the client for SQL Server, but that really
won't work either as SQL Std, and EE won't install except on NT/W2k Server.

So what you need to look at is the MSDE, Desktop Engine, which provides the
basic SQL Engine. Backup etc. is an issue as the MSDE does not have SQL
Agent, so they have to be done more manually. But you can connect to an MSDE
using the Enterprise Manager that you own as part of the Full SQL Server.

Consider the MSDE on the client and use replicatication (I think it's available
in MSDE), to maintain the data.

I haven't really worked with MSDE, just read info, so I'll leave you to dig
up the details.

KlK, MCSE


"Gabby" <Gabby_Buckworth@btinternet.com> wrote:
>
>I am currently developing a client-server system using visual basic and
sql
>server. I need to know how i can install SQL server on the client machine
>without having to install all components (such as enterprise manager) and
>still be able to backup, restore and configure the database on the client
>machine. I only need the core sql sever components. How can i still configure
>the database with minimal installed components?
>
>The reason for having sql server on both client and server is that the server
>is remote and connection can be lost between them. The client machine is
>obviously smaller in memory so having all the extra components installed
>will slow it down.
>
>Can any one help?
>
>Thanks
>
>