Results 1 to 6 of 6

Thread: work on SQL Server database without SQL Server installed

  1. #1

    Thread Starter
    Frenzied Member wengang's Avatar
    Join Date
    Mar 2000
    Location
    Beijing, China
    Posts
    1,602

    work on SQL Server database without SQL Server installed

    Hi all.
    Is there a way I can access and manipulate my SQL Server database without having the management studio?
    Any free app that others have used?

    Currently, I don't have anything installed, and I can only manipulate my database by SQL commands sent through a web page.
    Thanks.
    Wen Gang, Programmer
    VB6, QB, HTML, ASP, VBScript, Visual C++, Java

  2. #2
    Smooth Moperator techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,531

    Re: work on SQL Server database without SQL Server installed

    Well, depending on what you need it to do, you could build your own management studio like app. Use SMO (SQL Server Management Objects) and a connection.. a treeview... a text box or two... maybe an RTFTextBox....

    Is there a reason you can't install Management Studio?

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  3. #3
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,495

    Re: work on SQL Server database without SQL Server installed

    Powershell will work also
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

  4. #4

    Thread Starter
    Frenzied Member wengang's Avatar
    Join Date
    Mar 2000
    Location
    Beijing, China
    Posts
    1,602

    Re: work on SQL Server database without SQL Server installed

    Quote Originally Posted by techgnome View Post
    Well, depending on what you need it to do, you could build your own management studio like app. Use SMO (SQL Server Management Objects) and a connection.. a treeview... a text box or two... maybe an RTFTextBox....

    Is there a reason you can't install Management Studio?

    -tg
    Hmm. I don't know why I assumed it was part of the big expensive SQLServer install. Problem solved. Thanks.
    Wen Gang, Programmer
    VB6, QB, HTML, ASP, VBScript, Visual C++, Java

  5. #5
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    4,415

    Re: work on SQL Server database without SQL Server installed

    There is still DBeaver
    https://dbeaver.io/
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad

  6. #6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width