How would I access MS SQL Server with ubuntu 14.04. I tried using freetds I failed to understand the process and It was my first time learning sqlmap. I have tried to read for several hours but in vain. Just give me a clue a way to proceed. I have the IP address of the database but I don’t know how I can read it.
Advertisement
Answer
DbVisualizer (https://www.dbvis.com) should work for you. Its cross platform, fairly easy to use and can connect to almost any kind of database. You’ll need the IP address, port, username and password, just create a new connection and provide the connection details. You then can see the tables and run SQL against them (you’re gonnna need to learn SQL if you don’t know it).
It would help to know what you are trying to migrate. Im assuming the Ubuntu server is where the data is, but you haven’t said what platform you are using or what format you are trying to get the data in. Are you just trying to clone the entire database to your local MySQL process?