Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Microsoft SQL Server Management Studio Express Expand / Collapse
Author
Message
Posted Tuesday, December 4, 2012 11:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, December 9, 2012 9:25 AM
Points: 8, Visits: 33
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
Post #1392632
Posted Tuesday, December 4, 2012 12:25 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:19 AM
Points: 1,951, Visits: 2,123
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.
Post #1392656
Posted Tuesday, December 4, 2012 10:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, December 9, 2012 9:25 AM
Points: 8, Visits: 33
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
Post #1392783
Posted Wednesday, December 5, 2012 1:01 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:19 AM
Points: 1,951, Visits: 2,123
I'm not sure what you mean by install on a TP (not a server)?
Post #1393180
Posted Wednesday, December 5, 2012 10:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, December 9, 2012 9:25 AM
Points: 8, Visits: 33
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.
Post #1393322
Posted Thursday, December 6, 2012 7:08 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:19 AM
Points: 1,951, Visits: 2,123
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.
Post #1393505
Posted Thursday, December 6, 2012 8:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 12, 2014 11:59 AM
Points: 191, Visits: 904
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.
Post #1393570
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse