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
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 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
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4820 Visits: 3942
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
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 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
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4820 Visits: 3942
I'm not sure what you mean by install on a TP (not a server)?
sripriya_k
sripriya_k
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 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
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4820 Visits: 3942
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
SSC-Addicted
SSC-Addicted (416 reputation)SSC-Addicted (416 reputation)SSC-Addicted (416 reputation)SSC-Addicted (416 reputation)SSC-Addicted (416 reputation)SSC-Addicted (416 reputation)SSC-Addicted (416 reputation)SSC-Addicted (416 reputation)

Group: General Forum Members
Points: 416 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