locked
SQL server 2019 generate scripts RRS feed

  • Question

  • 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. 

    • Moved by Dave PatrickMVP Tuesday, January 5, 2021 7:18 PM looking for forum
    Monday, January 4, 2021 1:10 PM

All replies

  • I'd try asking for help over here.

    sql-server-general - Microsoft Q&A

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    Monday, January 4, 2021 1:27 PM