Results 1 to 7 of 7

Thread: MSDE/SQLServer 2000 Personal

  1. Jan 14th, 2003, 07:45 PM #1
    WALDO
    WALDO is offline

    Thread Starter
    Addicted Member WALDO's Avatar
    Join Date
    Aug 2002
    Location
    Swing of Prussia, PA
    Posts
    244

    MSDE/SQLServer 2000 Personal

    Does anyone have a copy of SQLServer 2000 Personal Edition they'd be willing to let me "acquire"?
    Last edited by WALDO; Jan 15th, 2003 at 09:44 AM.
    Reply With Quote Reply With Quote
  2. Jan 14th, 2003, 09:52 PM #2
    Beacon
    Beacon is offline
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    No but why not use MSDE.

    b
    Reply With Quote Reply With Quote
  3. Jan 14th, 2003, 11:46 PM #3
    WALDO
    WALDO is offline

    Thread Starter
    Addicted Member WALDO's Avatar
    Join Date
    Aug 2002
    Location
    Swing of Prussia, PA
    Posts
    244
    The idea is to get a working copy of SQL Server 2000 on my Windows 98 laptop.

    I have SS2K on a bunch of my Win2K machines, but I really need to replicate an instance of one of my servers on the laptop. As far as I understand, SS2K Personal can run on Win98.

    Can MSDE accomplish this for me?
    Reply With Quote Reply With Quote
  4. Jan 15th, 2003, 05:27 AM #4
    goatsucker
    goatsucker is offline
    Hyperactive Member goatsucker's Avatar
    Join Date
    Dec 2002
    Location
    Leeds, England
    Posts
    283
    Microsoft say that MSDE is "binary compatible with SQL Server" and is optimised for fewer users. I have used it and found no differences. I would give it a try.
    After all "Rust Never Sleeps"
    Reply With Quote Reply With Quote
  6. Jan 15th, 2003, 09:42 AM #5
    WALDO
    WALDO is offline

    Thread Starter
    Addicted Member WALDO's Avatar
    Join Date
    Aug 2002
    Location
    Swing of Prussia, PA
    Posts
    244
    I've been doing some research into MSDE. So far it looks good. The problem is I can't find any definitive answers from Microsoft. (No surprise there)

    Maybe one of you guys can answer some of my questions.

    How can I install MSDE?
    Can I manage MSDE just like I can SS2K? (Enterprise Manager/MMC)
    Does it also do Stored Procs, User-Defined Types, & User-Defined Functions?
    Can I change the "database" at will or is it just a replica of an existing server?
    If I can change it, how can I sync it back up to another server?
    If not, how can I replicate it from an existing server?
    Do I have to change my ADO connection strings? To what?
    Reply With Quote Reply With Quote
  7. Jan 15th, 2003, 10:04 AM #6
    goatsucker
    goatsucker is offline
    Hyperactive Member goatsucker's Avatar
    Join Date
    Dec 2002
    Location
    Leeds, England
    Posts
    283
    TO go through your points in turn

    How can I install MSDE?
    Pretty straightforwardly. As I Remember there is an MSDE folder on the Office 2000 Developer disk with a Setup.exe file there. I just ran that. I belive the SQL 2000 version comes with Office XP.

    Can I manage MSDE just like I can SS2K? (Enterprise Manager/MMC)
    YES, just connect to as you would any other.


    Does it also do Stored Procs, User-Defined Types, & User-Defined Functions?
    YES

    Can I change the "database" at will or is it just a replica of an existing server?
    You can change, add or remove the dbs just as you can in SQL 7 or 2000

    Do I have to change my ADO connection strings?
    No. I have used MSDE during development, and had to change nothing when it the code was deployed onto a SQL 7 box.

    I don't know about Syncing and replication, but I would be very surprised if they were different.
    After all "Rust Never Sleeps"
    Reply With Quote Reply With Quote
  8. Jan 15th, 2003, 10:13 AM #7
    WALDO
    WALDO is offline

    Thread Starter
    Addicted Member WALDO's Avatar
    Join Date
    Aug 2002
    Location
    Swing of Prussia, PA
    Posts
    244

    Coolness

    I'll give it a try.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width