SQL Server vs The Free Version

[Denaes]

I don't have SQL Server. I might be starting a project which would require its use though; A network with a server and 15+ stations that want realtime database transactions (Currently its a DOS based system performing all transactions in sequential order overnight, often backlogging orders)

 

I have two computers, my "Tank" - the desktop, and my laptop. Could I get the free version of SQL Server (MSE is it?) which is rather limited, to develop my project, then get SQL Server 2000 (or 2002) at a later date and plug it all in together?

 

I guess the question I'm getting at is, are they both compatable?

 

Would I have to change my code around or do anything differently when I get SQL Server 2000?

[Robby]

The code would stay the same, they are compatable.

[Denaes]

Sweet :D

[Nerseus]

Actually, they're the SAME engine. You can backup databases, users, etc. from one and restore to the other. The full SQL Server comes with a bunch of nifty tools and the ability to license more users, but costs a lot more. The free version is harder to set up (command line switches, no GUI) and "tweak" without some extra tools, but is free.

 

If you have Visual Studio (not sure which version - I use Enterprise Architect), you can tweak many things in the MSDE database through VS's Server Explorer. You can add tables, keys, etc. there.

 

-nerseus

[Denaes]

MSDE only allows something like 5 connections or something like that, right?

 

If there is any way I can get away with setting up the free version on a clients server rather than getting the $2000 version, I would. Oh yes, I would.

 

But there are 5 computers that will be using the database for sales and another 4+ that use the same application (not nessicarily the same database) for accounting and whatnot.

 

I just don't want a salesperson to get locked out of the database because someone is pooling data in a backroom, or keep the back office personel out of the database loop.

 

Eh, at least I can proceed with the MSDE and see how it seems to work out. I guess most transactions should be quick "in and out" actions... maybe MSDE would be good enough.

[samsmithnz]

IT might be good enough, and you might be able to keep enough connections closed so that one of the 9 people can always get access, but its not very scalable. What happens in 2 months if they hire three more people? How will you explain that you need to spend that 2K then?

 

I think its best to be upfront about this, explain that if they use the free version theres a good chance they will need to buy SQL Server anyway. Otherwise your 2K might be budgeted away to somewhere else and then you'll really be in trouble.