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.
-
1Are 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
-
1Sorry, 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
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.
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
-
1
You can download some free administration tool, for example, SQL Manager Lite for SQL Server. It does not require additional client libraries.