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