Does anyone have a copy of SQLServer 2000 Personal Edition they'd be willing to let me "acquire"?
Printable View
Does anyone have a copy of SQLServer 2000 Personal Edition they'd be willing to let me "acquire"?
No but why not use MSDE.
b :)
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?
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.
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?
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.
I'll give it a try.