Hi Team,
I was working with SQL server 2019 as a database for my application. In that i need some information regarding
"generate scripts" option available with sql server 2019.
In order to have a backup of our database with current data table information during migration or for any other purposes , we can do it with generate scripts by right clicking the database and follow the necessary steps.
The generated script can be saved locally and run in future to restore the current state.
Clarification case:
The above mentioned scenario was done using manual method. Is there any sql calls from source code say vb6 in order to achieve current state backup of database using generate scripts without any manual intervention.
Can anyone suggest any option.
PS:
In MYsql the above operation was done using MYSQLdumb.exe.