locked
bcp error is coming while migrating data to sql azure. RRS feed

  • Question

  • Hi,

    Running in bcp script results in the following error :

    The application has failed to start because its side-by-side configuration is 

    in correct. Please see the application event log or use the command-line 

    sxstrace.exe tool for more detail.

    Please note that this machine doesn't have sql server installed.

    Please tell me which components(minimal) i need to install to run the bcp script.

    Thanks in Advance :)

    Wednesday, November 14, 2012 4:59 AM

Answers

  • Hi Ind_Alchemist,

    You can use the SQL Server bcp utility for high-performance data movement when migrating a SQL Server database to Windows Azure SQL Database. You first use bcp to copy the data out of a source table and into a data file. You then run it again to copy the data from the data file into the destination table. bcp moves only data, so it must be used with another process for database schema migration.

    Please follow the links step-by-step to migrate a databse to SQL Azure.

    How to: Use bcp to Migrate a Database to Windows Azure SQL Database: http://msdn.microsoft.com/en-us/library/windowsazure/jj156153.aspx.

    Thanks.


    Maggie Luo

    TechNet Community Support

    • Marked as answer by Maggie Luo Sunday, November 25, 2012 1:42 PM
    Tuesday, November 20, 2012 8:10 AM

All replies

  • Hi Ind_Alchemist,

    You can use the SQL Server bcp utility for high-performance data movement when migrating a SQL Server database to Windows Azure SQL Database. You first use bcp to copy the data out of a source table and into a data file. You then run it again to copy the data from the data file into the destination table. bcp moves only data, so it must be used with another process for database schema migration.

    Please follow the links step-by-step to migrate a databse to SQL Azure.

    How to: Use bcp to Migrate a Database to Windows Azure SQL Database: http://msdn.microsoft.com/en-us/library/windowsazure/jj156153.aspx.

    Thanks.


    Maggie Luo

    TechNet Community Support

    • Marked as answer by Maggie Luo Sunday, November 25, 2012 1:42 PM
    Tuesday, November 20, 2012 8:10 AM
  • Hello , this tutorial can help you :) 

    https://code.msdn.microsoft.com/The-best-way-to-migrate-6c4a7326

    Please rate it if it solve your problem :)

    Monday, December 28, 2015 2:13 PM
  • Your link doesn't work.  As someone that works for MS I would expect you to know how to post clickable links as well.  Thanks for spamming the forums and resurrecting a bunch of dead old posts.
    Monday, December 28, 2015 3:02 PM