How to transfer data from a local MSSQL Server to Azure SQL Server?

[Shinji]

I can transfer data from Azure SQL to a Node.js server, but I encounter an error when I try to transfer data from a Local SQL Server to Azure SQL using a trigger. I have established a Linked Server connection. I added a trigger to the local database, but the trigger gives an error because the Linked Server name is too long ([Linkedserver].[DatabaseName].[TableName]). Can you suggest a solution for this?

We do not have access to the Azure SQL management portal and do not have the authority to use it. If you can assist me without using the portal, I would appreciate it.