I have a database on a sql server on one server that has tables and information.
I also have a mysql database on another server.
All database names, table names, number of tables, rows and columns are exactly the same on both servers.
Now I want to sync the information of these two databases together.
For example, if a row is added on server one, this row will be automatically added on the second server. Or, if a table is deleted on server 1, that table will be deleted from server 2 at the same time.
The point is that the servers are on two separate networks. One is active on the internal network and the other on the Internet.
I don’t know if I was able to convey my point or not. I hope you can help me.

My current database consists of vehicle workshop related information. One of the base table is workshop_details with primary key as workshop_id.That is a 4 digit integer of datatype.
We do have one column named as authorised_by_shell with string datatype value Y/N.
Now a new requirement came to split an existing workshop into 2 workshops without changing the primary key(workshop_id).

SELECT view_fav_items.* ,1 AS fav FROM view_fav_items INNER JOIN fav ON fav.fav_itmesid = view_fav_items.items_id AND fav.fav_userid = 17 UNION ALL SELECT * , 0 AS fav FROM view_fav_items WHERE items_id != (SELECT view_fav_items.items_id FROM view_fav_items INNER JOIN fav ON fav.fav_itmesid = view_fav_items.items_id AND fav.fav_userid = 17) SELECT view_fav_items.* ,1 AS fav FROM view_fav_itemsINNER JOIN fav […]

I get the following error when trying to connect to SQL Server:

We want to data migrate MSSQL to MySQL. Which tools we can for this data migration

I want to make monday as the start day of the week for a specific table. I have searched all the net but couldnt find any proper solution. @@datefirst will be useful for the current session but my task is to set the startday for a table

Please provide a generic query that will produce the following result set in SQL.

This error occurs in every table, every time I execute query it in my database.First table

Length should be 20;

by applying this function on a column, Is the returned records is returned in order?
CREATE FUNCTION [dbo].[Remove] (@encrypt VARCHAR(200))
RETURNS TABLE
AS RETURN
(
WITH Numbers AS (
SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS N
FROM master.dbo.spt_values)
SELECT
word = STRING_AGG(SUBSTRING(@encrypt, Numbers.N, 1), ”) WITHIN GROUP (ORDER BY
Numbers.N)
FROM Numbers
WHERE (Numbers.N – 1) % 2 <> 0
AND Numbers.N <= LEN(@encrypt)
);