Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Migrating data from local MSSQL server generated script to Azure web app MSSQL server

Discussion in 'General' started by umen, Dec 24, 2016.

  1. umen

    umen New Member

    Migrating data from local MSSQL server generated script to Azure web app MSSQL server , when it failed executing from SQL Management studio

    i have generated 200 mega data script from local MSSQL server , which i generated via Tasks -> generate script in the SQL engagement studio.
    When i try to execute it from the SQL Management studio i get massage that i have noא enough memory to run it , which is weird i have 16 giga ram on my pc.
    So my question is simple :
    How can i update my remote MSSQL server with the data script .
    can i configure SQL Management studio to use more memory or there is better way to execute big script .
    Thanks

Share This Page