SQL Sever Client

  • I am working on sql server 2008. I don't want to give complete sql server 2008 to my clients. Is there any client version available for sql server 2008, how to get it. [

  • Please explain a bit further.

    Are you talking about tools to manage and query SQL? If so give them SSMS and limit what they can do to the database via security.

  • vineet.007.mm (8/8/2012)


    I am working on sql server 2008. I don't want to give complete sql server 2008 to my clients. Is there any client version available for sql server 2008, how to get it. [

    Hi!

    If I understood you correctly, you question is about how to deploy app on per user machine with per user db on that machine?

    You may deploy a free version of sql express, use localDB, or sql server compact - but you have to deploy sql server engine on users machine.

    Here is a good artice comparing options SQL Express v LocalDB v SQL Compact Edition, here is some guides about deploying sql server How to deploy SQL Server 2008 Express as a prerequisite with ClickOnce, How to: Deploy a SQL Server Compact Edition Database with an Application.

    Hope it will be helpful.


    I am really sorry for my poor gramma. And I hope that value of my answers will outweigh the harm for your eyes.
    Blog: http://somewheresomehow.ru[/url]
    Twitter: @SomewereSomehow

  • If you are asking about the difference between installing Management Studio to be able to query a SQL 2008 DB then No... there is not just client to query a db like there was in SQL2000. Unless you want to get a free tool like Squirrel or Toad.

Viewing 4 posts - 1 through 3 (of 3 total)

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