Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   How do I centralize sql server database (http://www.go4expert.com/forums/i-centralize-sql-server-database-t5247/)

rhaazy 13Jul2007 19:07

How do I centralize sql server database
 
I am developing around sql server express 2005, and I have a database
that I, and a few other people work on. Right now whenever someone
needs to make changes, they need to go to where the database is on the
server, copy it locally, attatch it, make changes, detatch, and copy
it back over to the server... There must be another way. I tried
adding the database to a project solution in SourceSafe, but that
doesn't seem to make things any easier.

Anyone have any suggestions?

shabbir 13Jul2007 19:28

Re: How do I centralize sql server database
 
Have a database on the server and have the Enterprise Edition in the clients from where you want to edit and change the database from the client.

rhaazy 13Jul2007 19:45

Re: How do I centralize sql server database
 
Thank you for your quick reply.

My SQL server background is quite limited, perhaps you could elaborate a little on your explanation.. I am not quite sure what you mean by Enterprise Edition.

rhaazy 13Jul2007 19:50

Re: How do I centralize sql server database
 
By enterprise edition you mean.... as opposed to the express edition that I am currently using.

I am not using enterprise edition, I am using sql server 2005 express.

shabbir 13Jul2007 22:03

Re: How do I centralize sql server database
 
What I meant is SQL Server comes with Query browser that you should install in the clients and that only the Enterprise edition has that facility and not with the personal editions as far as I know. I may be wrong.

rhaazy 13Jul2007 23:22

Re: How do I centralize sql server database
 
I guess my question can really be simplified down to this statement:

How does one remotely access a database through SQL Server Management Studio Express?

rhaazy 13Jul2007 23:38

Re: How do I centralize sql server database
 
Ok, I figured it out, I feel kind of silly now that I realize how simple my problem was... Thanks for your help.


All times are GMT +5.5. The time now is 01:07.