MSDE (+SQL Server?) File: Copy/Distribute


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: MSDE (+SQL Server?) File: Copy/Distribute

  1. #1
    Wesley Davis Guest

    MSDE (+SQL Server?) File: Copy/Distribute


    I've been doing client/server since VB 3 days (and straight-up VB since ver
    1), and Access since version 2. So the issue of creating & maintaining the
    database is a done deal.

    What I need to know, now that we have the MSDE engine and ability to do "local"
    client/server databases with both VB and Access, I need to find out where
    the data is stored in/by MSDE so I can distribute it with an application
    (in some cases there are both VB and Access versions). Unlike the old client/server,
    where it never moved short of a large migration effort, or the old Access
    (*.mdb) databases which were a great container idea, I can't seem to locate
    in the Microsoft docs (is this anything new?) where/how to do this. I've
    seen enough times the "how to create" and so on - and I know the admin tools,
    but all I want to do is, in some cases, just zip up the data file and email
    it to a buddy (e.g. in my ski club, to give one example of an after-hours
    project).

    I'd like to think this is simple, but where the data is and what the file
    names are is not clear to me. Running Visual Studio Enterprise 6, NT 4 SP
    6a, Office 2000 Premium.

    Thanks in advance for any help.

  2. #2
    Joe Fallon Guest

    Re: MSDE (+SQL Server?) File: Copy/Distribute

    MSDE is just a limited version of SQL 7.0.
    It stores data in exactly the same way.

    There is a file on your hard drive in \mssql\data folder with the name of
    your database.

    I think you can just copy this file and send it to someone else.
    --
    Joe
    Access MVP


    Wesley Davis <wdavis2@nycap.rr.com> wrote in message
    news:3986c8fa$1@news.devx.com...
    >
    > I've been doing client/server since VB 3 days (and straight-up VB since

    ver
    > 1), and Access since version 2. So the issue of creating & maintaining the
    > database is a done deal.
    >
    > What I need to know, now that we have the MSDE engine and ability to do

    "local"
    > client/server databases with both VB and Access, I need to find out where
    > the data is stored in/by MSDE so I can distribute it with an application
    > (in some cases there are both VB and Access versions). Unlike the old

    client/server,
    > where it never moved short of a large migration effort, or the old Access
    > (*.mdb) databases which were a great container idea, I can't seem to

    locate
    > in the Microsoft docs (is this anything new?) where/how to do this. I've
    > seen enough times the "how to create" and so on - and I know the admin

    tools,
    > but all I want to do is, in some cases, just zip up the data file and

    email
    > it to a buddy (e.g. in my ski club, to give one example of an after-hours
    > project).
    >
    > I'd like to think this is simple, but where the data is and what the file
    > names are is not clear to me. Running Visual Studio Enterprise 6, NT 4 SP
    > 6a, Office 2000 Premium.
    >
    > Thanks in advance for any help.




  3. #3
    Wesley Davis Guest

    Re: MSDE (+SQL Server?) File: Copy/Distribute


    Joe,
    I Finally tracked down the SQL Server data directory and looked; yes, there
    is ... are 2 files with that database name. One is about 2x the size of the
    other. What's the difference, if any? I would guess I'd need both, because
    of the size of the smaller one being rather significant. Am I correct?


    Joe Fallon wrote:
    >MSDE is just a limited version of SQL 7.0.
    >It stores data in exactly the same way.
    >
    >There is a file on your hard drive in \mssql\data folder with the name of
    >your database.



  4. #4
    sb Guest

    Re: MSDE (+SQL Server?) File: Copy/Distribute

    I've been reading and learning MSDE, I come from Access MDB files. MSDE is
    GREAT, will take some time to understand it. YES you can copy the database
    files and email them, but in order for the other guy to see it and read it,
    it must be ATTACHED the new server before it can be used. Look at the MS web
    under MSDE, you have 2 examples.
    Good luck. SB
    "Wesley Davis" <wdavis@imps0014.us.dg.com> wrote in message
    news:398ef839$1@news.devx.com...
    >
    > Joe,
    > I Finally tracked down the SQL Server data directory and looked; yes,

    there
    > is ... are 2 files with that database name. One is about 2x the size of

    the
    > other. What's the difference, if any? I would guess I'd need both, because
    > of the size of the smaller one being rather significant. Am I correct?
    >
    >
    > Joe Fallon wrote:
    > >MSDE is just a limited version of SQL 7.0.
    > >It stores data in exactly the same way.
    > >
    > >There is a file on your hard drive in \mssql\data folder with the name of
    > >your database.

    >




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