There is a program in c #: the program itself + a database created in MS SQL Server Manager Studio. At the moment, the database is on my PC (Windows), but later it needs to be uploaded to the server with Linucs (database management via phpMyAdmin). Question what difficulties may arise with unloading the database? Whether there will be problems if on the server mySQL and I have MS SQL Server? The C # program uses SqlClient (SqlCommand, SqlConnection ect) and on the local Windows server everything works fine, but will there be any problems when the database is transferred to a remote Linucs?

  • one
    какие могут возникнуть сложности с выгрузкой БД ? Не будет ли проблем если на сервере mySQL а у меня MS SQL Server ? Difficulties arise, and large. Not all MS SQL constructs are implemented in MySQL, some outwardly the same actually work differently, and in some places it is difficult to choose an analogue. - Akina
  • constructions are requests? mySQL and MS SQL Server Manager Studio are different DBMS and not different query languages? - Sergey
  • The dialects of languages ​​are different. - sp7
  • What do you mean by dialects? An example I have a query: "select * from table" and the table was created in SQL Manager Studio. What will be the difficulty for the server to work with it? - Sergey
  • one
    @ Sergey The simplest designs will work everywhere. But as soon as it comes to something more or less complex, the entertainment will begin. For example, in MySQL, instead of SELECT TOP x ... will have to use SELECT ... LIMIT x , and to implement SELECT TOP x PERCENT ... will need to turn around a lot. - Akina

1 answer 1

You will have a lot of problems. Use the .Net provider of MySQL, install MySQL on a working machine, with the help of MySQLWorkbench, try to manually transfer the database from MS SQL to MySQL using script generation.
Further maintenance and refinement can be done MySQLWorkbench, it is better and more convenient than phpMyAdmin. Rewrite code using the classes MySql.Data.MySqlClient, almost everything is similar to System.Data.SQLClient

  • Is the working machine in this case my PC or server? Where to put the workbench? - Sergey
  • Your Windows machine on which you encode. - Azamat Galiyev
  • And for further refinement, instead of phpMyadmin, can Workbench be installed? - Sergey
  • Of course, unlike phpMyAdmin, php + apache or nginxp is no longer needed, you will have a pure Linux machine for the database server. - Azamat Galiyev