Microsoft SQL Server Management Studio Express

Question

Microsoft SQL Server Management Studio Express

sripriya_k

Old Hand

Points: 368
More actions
December 4, 2012 at 11:09 am

#271560

Hello All,
We are trying to create a centralised DB which could be used from a client location. Please let me know if Management studio express could be used for this purpose.
Its not a complex one. Everytime a user logs in to a standalone application, the ms access db has to synchronise with the centralised db based on network availability and vice versa when required.
Could this be achieved using Studio express 2005.
Basically could Management studio express be used to create a Database?
Thanks in advance.
Regards,
K. Sripriya

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 1

Management Studio Express is the client-side tool that you can use to create, setup, and administer a database that is local or on a server. If you're asking if SQL Server Express could act as that central database, the answer is, it depends. 😉 Check if Express has the features you need:

http://msdn.microsoft.com/en-US/library/ms143761(v=SQL.90).aspx

Of course for a new system, you'd probably want to consider SQL Server Express versions 2008 R2 or 2012

http://msdn.microsoft.com/en-us/library/cc645993.aspx

the newer versions allow a database up to 10 gigabytes in size instead of just 2, and will be supported longer. To synchronize an Express database with Access will require you to do the coding to update the data, and handle cases where data is modified in local Access and central SQL Server db between synchronizations.

sripriya_k Old Hand Points: 368 More actions · Answer 2

Thanks a lot for your response.

Please do let me know if we can use the express edition in a normal TP for creating a centralised DB instead of having it on a server.

Assume I have the express edition installed on my TP (which is not a server). I create a DB. This DB has to be linked to MS Access DB from various locations (a synchronisation of the two db's the local and the centralised). Would installing Express edition solve the above purpose.

Also, let me know if Express edition is better than Mysql.

Thanks in advance.

Regards,

K. Sripriya

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 3

I'm not sure what you mean by install on a TP (not a server)?

sripriya_k Old Hand Points: 368 More actions · Answer 4

What I mean is if the express edition is not installed in a system which is not configured as a server..

Can this be used to create a centralised DB which could be accessed from the client machines.

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 5

Esentially that machine would have to be turned on all the time, so clients could connect to it and maintenance such as database backups, etc, could be run. That machine would have to be acting as a server. If it has Windows XP or 7 operating system on it, then I think there may be some licensing considerations as to how many clients could connect to it, but I'm not really an expert at that.

vikingDBA SSCertifiable Points: 5356 More actions · Answer 6

Check for the maximum number of connections that the os allows to the workstation. It may be 10 for non-servers. Whatever the number, only that many SQL connections can be made concurrently at any given time.