SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Microsoft SQL Server Management Studio Express


Microsoft SQL Server Management Studio Express

Author
Message
sripriya_k
sripriya_k
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 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
Chris Harshman
Chris Harshman
SSC-Insane
SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)

Group: General Forum Members
Points: 22620 Visits: 5742
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
sripriya_k
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 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
Chris Harshman
Chris Harshman
SSC-Insane
SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)

Group: General Forum Members
Points: 22620 Visits: 5742
I'm not sure what you mean by install on a TP (not a server)?
sripriya_k
sripriya_k
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 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.
Chris Harshman
Chris Harshman
SSC-Insane
SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)

Group: General Forum Members
Points: 22620 Visits: 5742
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
vikingDBA
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3294 Visits: 929
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search