I have local database with a lot of data for developing a site...now I want to publish this project. I wanna know. how Can I bring this data from local to online database?

CodePudding user response：

While you haven't specified database, tools, the answer can be extraordinary as well.

Let's imagine that you have local MS SQL DB and Azure SQL db.

There is not a standard method how to do this. Right click on the database. Generate scripts. Then select all objects that you need
then go to advanced and change types of data to script to:Scheme and data

as the result you will have full damp of your database that you have to run on AZURE SQL.

ps. more ideas only if you provide more details

CodePudding user response：

That I usually use is Azure and you can publish you app and database to it direct from VS. Of course you can do is separate db or app. https://docs.microsoft.com/en-us/visualstudio/deployment/deploying-applications-services-and-components-resources?view=vs-2022