For Programmers: Free Programming Magazines  


Home > Archive > Clarion > April 2004 > SQL Server for end users









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author SQL Server for end users
Edvard Korsbęk

2004-03-30, 1:30 am

We have decided to change to SQL on our programs.
Our customers are schools and kindergartens.
They are administrated from the local City, and the administrator would of
cause want to be able to reuse the data from the schools - that says that I
should use a MS SQL server.
I have understood, that the database connectivity is a part of Windows
2000/XP professional - I.e that a PC with theese OS can run a MS SQL
database without any extra cost.
I have to create the empty MDF file with my MS SQL server and distribute it.
Is this correct - Or do I have to look at other SQL solutions?

--
Best regards

Edvard Korsbęk
+4570229998


Jason Berkan

2004-03-31, 11:30 am

On Tue, 30 Mar 2004 07:56:00 +0200, "Edvard Korsbęk" <info@bb-soft.dk>
wrote:
>I have understood, that the database connectivity is a part of Windows
>2000/XP professional - I.e that a PC with theese OS can run a MS SQL
>database without any extra cost.


To install the full blown version of SQL Server, you need a server
operating system, of which 2K and XP Pro are. The redistributable
engine MSDE runs on anything from Win98 up.

>I have to create the empty MDF file with my MS SQL server and distribute it.


You can create a new database (which consists of more than just an MDF
file) at the client site, using the client tools (full version) or
script commands through OSQL (MSDE/full version).

Jason
Theuns Snyman

2004-04-05, 8:30 am

To Distribute MSDE, you need a SQL Server developer license. There are
pretty cheap ( About $40 US)

Theuns Snyman


"Jason Berkan" <jason_berkan@canada.com> wrote in message
news:l8nl605srnmgb6qkgk5asrlnrkmrdn3p6s@
4ax.com...
> On Tue, 30 Mar 2004 07:56:00 +0200, "Edvard Korsbęk" <info@bb-soft.dk>
> wrote:
>
> To install the full blown version of SQL Server, you need a server
> operating system, of which 2K and XP Pro are. The redistributable
> engine MSDE runs on anything from Win98 up.
>
it.[color=darkred]
>
> You can create a new database (which consists of more than just an MDF
> file) at the client site, using the client tools (full version) or
> script commands through OSQL (MSDE/full version).
>
> Jason



Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com