Post reply

Migrating data from local SQL Server generated script to Azure web app SQL Server, when it failed executing from SQL Server Management Studio

  • December 24, 2016 at 7:45 am

    #401265

    I have generated 200 mega data script from local SQL Server, which I generated via Tasks -> Generate Script in SQL Server Management Studio.

    When I try to execute it from the SQL Server Management Studio, I get massage that I have not enough memory to run it, which is weird I have 16 gigabytes of ram in my pc.

    So my question is simple: how can I update my remote SQL Server with the data script ?

    Can I configure SQL Server Management Studio to use more memory or there is better way to execute big script?

    Thanks

  • December 24, 2016 at 8:03 am

    #1919577

    meiry242 (12/24/2016)

    I have generated 200 mega data script from local SQL Server, which I generated via Tasks -> Generate Script in SQL Server Management Studio.

    When I try to execute it from the SQL Server Management Studio, I get massage that I have not enough memory to run it, which is weird I have 16 gigabytes of ram in my pc.

    So my question is simple: how can I update my remote SQL Server with the data script ?

    Can I configure SQL Server Management Studio to use more memory or there is better way to execute big script?

    Thanks

    Try executing the file using SQLCMD. Have a read here[/url] for some details, if you're not familiar with it.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • December 24, 2016 at 10:36 am

    #1919591

    Thank you very much for you replay , i found info about this tool ,

    but i haven't found any info about my situation where i need to fill data from my local db

    in sql script format to remote azure mssql db .

    tutorial on that will be very helpful .

    Thanks again !

  • December 24, 2016 at 11:16 am

    #1919594

    meiry242 (12/24/2016)

    Thank you very much for you replay , i found info about this tool ,

    but i haven't found any info about my situation where i need to fill data from my local db

    in sql script format to remote azure mssql db .

    tutorial on that will be very helpful .

    Thanks again !

    I'm not very familiar with Azure, but if you are merely asking how to script data as INSERT statements, I can help with that – please clarify.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • December 25, 2016 at 9:38 pm

    This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply