Installing MS SQL 7 engine on client machine


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Installing MS SQL 7 engine on client machine

Hybrid View

  1. #1
    Gabby Guest

    Installing MS SQL 7 engine on client machine


    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



  2. #2
    kevin knudson Guest

    Re: Installing MS SQL 7 engine on client machine


    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
    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center