Managing MSSQL from Linux workstation

[Igoraus]

Hi.

It's posible to read, delete, update, insert and mutch more in MsSQL from Linux workstation.

...:p :p

[ilja]

Is it only a database? ODBC and PHP can be used to work with it. (See here http://www.phpbuilder.com/columns/alberto20000919.php3 )

[fjleal]

Of course it is! Do you know SQL? You should know, if you're working with client-server DataBase Management Systems (DBMS). Use any SQL client to connect to the server. I use DBVisualizer for connecting to SQL Server servers and PostgreSQL servers (http://www.minq.se/products/dbvis/). DBVisulaizer has a free edition. It displays a tree with your database objects, creates a graphical representation of your relacional schema, has a SQL client with syntax coloring, and many more!
DBVisualizer is a Java application, so it uses JDBC drivers to connect to databases. The SQL Server driver is freely available from the Microsoft website.

[ilja]

Here in server it fits better ;)

[Ug]

You can use a Webmin interface too.

[marco60tag]

You can use MySQL Control Center tool.
It runs on linux and windows.
You can easily download it from www.mysql.com for free.

It has a very intuitive and productive interface.

[Igoraus]

I hawe MS application's and thay need ODBC.
With wine I can start window app, but problem is haw to connect thrue ODBC to MSSQL on Window server?


:( :( :( :confused: :confused: :o

[jeru]

I don't know that wine has any of the windows DSN stuff implimented. If the windows app doesn't directly connect via odbc by itself with it's own libraries, you may be out of luck. (I don't know wine very well thou)

You do however have UnixODBC to do the same type of thing nativily with native apps such as openoffice. Maybe wine supports that in translation???

But if all you need to do is 'manage' a mysql server, get MySQL Control Center like marco60tag said and you could also have use for MySQL Admin. Or if nothing else, you can use the mysql-client CLI to do anything you want also. (or even phpmyadmin if you want to set all that up)

You shouldn't need any windows apps to 'manage' it. You'd only need them to run with it in an offshoot application based on mysql. And that would then fall into the 'what app are you trying to use' catagory.

MySQL CC
http://www.mysql.com/products/mysqlcc/
http://dev.mysql.com/downloads/mysqlcc.html

MySQL Admin
http://www.mysql.com/products/administrator/
http://dev.mysql.com/downloads/administrator/