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

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
 
Top