| Author |
 Topic  |
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
 Posted - 16 December 2004 : 14:18:22
|
I've been searching around for ways to play with sql server, without buying it, and I came up with this
I'm just wondering if anybody has used it before, and whether or not it allows connection to remote SQL databases. |
-Stim |
Edited by - Da_Stimulator on 16 December 2004 14:19:01 |
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 16 December 2004 : 16:16:06
|
It's great to testing stuff locally and for use with applications. I've read many technical documents referring to it's limitations, but I've developed an application that uses MSDE as the database with well over 30 users (about 15 concurrently) and have not felt a performance degradation.
To answer your questions, yes... you can use it remotely. It is truly a SQL Server so you use the same exact connection types as you would an SQL Server. Enterprise Manager is almost essential to manage it easily which does not come with MSDE nor is it free. However, you can do maintenance on an MSDE database with certain development tools like Visual Studio and even some stuff can be accomplished using linked tables in an Access database. However, Enterprise Manager is the way to go, especially if you ever plan to use SQL Server in the future. |
 |
 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 16 December 2004 : 16:47:58
|
You might want to invest $50.00 or so in the SQL Server Developer Edition which includes all the client tools, and you'll have Enterprise Manager, Query Analyzer, DTS & all those goodies. It's great for development, testing and learning.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 17 December 2004 : 02:49:59
|
or something like Aquafold which doesn't do a bad job (it's also free and supports multiple database types)
http://www.aquafold.com |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 17 December 2004 : 03:21:59
|
quote:
Originally posted by Gremlin
or something like Aquafold which doesn't do a bad job (it's also free and supports multiple database types)
http://www.aquafold.com
Impressive. I just spent 5 minutes playing with it on my MSSQL server and it does quite a lot. Not sure if it will replace my Enterprise Manager, but considering it can be used on multiple database types, it was definitely a good recommendation. |
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 17 December 2004 : 05:06:47
|
I have to recomend developer edition over desktop edition simply because the desktop edition seems to run behind on the patch curve.
You wouldn't want to get slammed with a worm that was patched on other versions of SQL but not on the desktop edition . . . if you catch my dift. |
 Nathan Bales
CoreBoard | Active Users Download |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 17 December 2004 : 06:21:59
|
MSDE was patched for slammer! However, it is designed and intended to be a replacement (and upgrade path) for Jet, so don't expect it to perform as well as SQL Server Proper! Also, you may want to look at the licensing - as I recall, you should get a full server license for web sites :)
OK - Enterprise Mangler^h^h^h^h^h^h^h Manager - it's an OK tool, but isql/query analyser is a far far better tool for almost any job you have to do - and it makes/helps you learn SQL too. If you're a heave EM user, try learning to use Query Analyser, and you'll see you are holding a very simple, very powerful tool, and soon you'll use it for everyday work in preference to EM. EM is great for odd tasks or for beginners, but it masks some of the power of SQL Server.
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 17 December 2004 : 09:09:27
|
Thx for all your input.
Does MSDE come with something similar to enterprise manager? I'm just looking for something to develop/learn on.
I'll d/l it and that aquafold thing, and see how it works out. If its not enough I guess I'll have to buy the full thing. |
-Stim |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 17 December 2004 : 13:31:14
|
quote:
Originally posted by Da_Stimulator
Does MSDE come with something similar to enterprise manager? I'm just looking for something to develop/learn on.
no it does not.
Unless you're willing to do things using scripts and command lines, find a data management utlity. You're really better of trying to get your hands on a copy of Developer Edition.
If you've never used SQL Server before, you're in for a bumpy ride. It is completely different (and can be overwhelming at first) from your normal application type pc databases. |
|
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 17 December 2004 : 13:57:28
|
| I've used enterprise manager remotely via desktop-connection before, and I'm quite familiar with it. I just want something of my own on my own pc for playing around with. |
-Stim |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 17 December 2004 : 13:58:48
|
| well simply have MSDE is not going to help much. you need the ability to easily create databases, tables, field types, security, etc. this can be done via command line, but it is not fun... at least not for me. |
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 17 December 2004 : 21:29:32
|
If you have Access 2000 or higher, you can use it as a graphical front end to manage your MSDE engine. You can do nearly all management tasks from Access that you can do using EM.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 17 December 2004 : 21:32:56
|
| I got access 2k2 :) |
-Stim |
|
|
|
Topic |
|
Topic Locked
