How to quickly upload a local MSSQL database to a Godaddy Server

I have read about how to upload a local MSSQL database to a Godaddy server because I purchased a Godaddy deluxe Plan (Windows) host, however, I have tested that the Godaddy host fully supports uploading local data through the SQL Server Enterprise Manager. Maybe I have not read it comprehensively, and some other people may have posted relevant posts, however, I 'd like to write it here to reduce the trouble for later users.
go to the Godaddy management background> databases> sqlserver> create database
the SQL Server database is created here, in the "allow direct database access" option on the right of the page, select "yes" to allow remote connection to the database, set the "SQL Server database/User Name" username and "password" password, after creation, the address of "Host Name" is obtained.
okay. Open the SQL Server Query analyzer on the Local Computer and fill in the above parameters. The connection is successful. Haha.
I am doing this next. I used the Enterprise Manager to run SQL scripts everywhere in the database to be uploaded locally, and then run the SQL script directly through the query analyzer. For the first time, I did not succeed, if the error message shows that you do not have the user permission, re-view the SQL script and replace all the original usernames with DBO, I want to add users defined in SQL scripts to schemas through the Godaddy SQL Server Web Admin management background, but I did not try this step. After completing the preceding steps, run the SQL script again through the query analyzer. The created table and stored procedure are displayed on the Godaddy SQL Server Web Admin Management page, my work is half done.
next, open the Enterprise Manager and export data to smoothly transfer the data to the Godaddy sqlserver server. My local database backup file is about 120 MB, the maximum number of table records is about 68000, and data export takes 50 minutes.

the above is my upload process, which is mainly for new users to save time. In fact, Godaddy MSSQL is not as troublesome as many people say, the above is the process of uploading the database, but I also want to give you some tips:
1. Try to use nvarchar or ntext as the Data Type of the text field of the database, do not select varchar. This is the reason why the question mark (_) is garbled in Chinese characters on the page displayed by many people. It is best to do it locally before uploading the database.
2. There is no problem with the data type. The page still displays garbled characters. There are many related posts in this forum. My website is developed using ASP, and this problem also occurs, the solution is to add <% @ codePage = "936" %> to the header file. Some users only add <% @ Language = "VBScript" %>, you can change it to <% @ Language = "VBScript" codePage = "936" %>
3. Chinese character string variables are often prone to problems in use, this can be forced to convert the data type by adding N to the variable. The Code is as follows:
Conn. execute ("select * from [user] Where name like '%" & T2 & "% 'order by id desc ")
during use, it is found that no query number or English is correct, but there is no query record in Chinese. This is because The data type is ignored by sqlserver and changed to:
Conn. execute ("select * from [user] Where name like n' %" & T2 & "% 'order by id desc")
Well, it's done.