0

I got office program. This program stores his data in SQL Server 2008 Express, but there is no management studio and no sqlcmd. How can i get into pure SQL tables, to use them in my plugin.

  • 1
    Are you asking how to query SQL Server from within a Microsoft Office application (i.e., Excel) macro? – Jon Seigel Apr 21 '14 at 13:40
  • I must analize database and then query SQL Server, but from my own application. – Ariel Grabijas Apr 21 '14 at 13:42
  • 1
    Sorry, I'm still trying to understand what you're doing. You're saying there's some application that stores it's data in SQL Server, and you're writing another application/plugin that needs to query that data? Is that correct? – Jon Seigel Apr 21 '14 at 14:18
  • Yes. That's correct. Right now i am trying to install sql server 2012, to query data from sql server 2008 with 2012 management studio, but i am not sure if it will work. Of course i will query data from sql server 2008 later with JDBC from my aplication, but first i must analize tables, columnts etc. – Ariel Grabijas Apr 21 '14 at 14:46
3

You can download SSMS 2012 or 2014 which is a full seperate download and then use it to access tables, etc

link: ssms 2012

can't comment on what/ how your plugin is.

0

osql from the command line should work as well as SQL Server Management Studio...either way you have to download the SQL Server client. TOAD also has a free tool for working with the database.

  • 3
    osql was replaced by sqlcmd and is deprecated in SQL 2012. – Mike Fal Apr 21 '14 at 15:50
  • 1
    @MikeFal: sqlcmd replaced osql in SQL Server 2005, actually ... – marc_s Apr 21 '14 at 20:51
0

You can download some free administration tool, for example, SQL Manager Lite for SQL Server. It does not require additional client libraries.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.