Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I was going through some theoretical concepts about SQL based databases. One thing that I found interesting was that MySql and MS SQL are Relational-SQL-Database Management-Systems.

Since they both are managing SQL databases, is it possible to create a database using one of them to be and use the other one to manipulate it??If yes could someone please show me how to do it..

share|improve this question

closed as not a real question by Jon Seigel, Paul White, dezso, Mark Storey-Smith, RolandoMySQLDBA Jan 22 at 2:20

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

1 Answer

up vote 2 down vote accepted

It's possible to do from MS SQL Server. You can configured a Linked server which will allow you to execute queries from the MS SQL Server to databases on the MySQL server. I believe that in this case the SQL Server is not executing the query; it's just acting as a client and passing the query to the MySQL server. So you'd have to use MySQL queries to manipulate the remote database. In my experience what I've done is just configured a linked server and then created views on the MS SQL Server for the queries I plan to pull from on the remote server. Then I can manipulate the data from the views as if it was from MS SQL Server.

MySQL has limited options with the FEDERATED engine, but can only access MySQL databases remotely.

However, in a general sense, just because two RDBMSs use SQL doesn't mean they're compatible. All RDBMSs use slightly different dialects of SQL and implement ANSI SQL in ways that aren't always consistent. MySQL especially is notorious for being different.

This is why you'll see software packages specify specific RDBMSs as being supported (sometimes only one). Additionally, each RDBMS handles the tasks of creating databases, configuring server settings, configuring replication, backup, etc. in entirely different and incompatible manners. Adding a user account to MySQL and MS SQL are entirely different processes in spite of the fact that the task goals are the same.

share|improve this answer

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