[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL azure migration

Posted on 2011-05-01
1
Medium Priority
?
1,153 Views
Last Modified: 2014-11-12
Hi,
I am getting this error when using the sqlazuremw.  my database has around 50 tables with data.  Some of the tables have thousands of records.  So I first created schem only and then ran it again for the data.  but i continue to get this error for all the tables.

Anybody have any insight into thisl...

SQLAzureMW could not find the number of rows copied in the BCP output.  Here is the BCP command:

BCP "[ForWebA].[dbo].[SampleTypeIndicies_TemplateForSetupEdit]" out "c:\SQLAzureMW\BCPData\dbo.SampleTypeIndicies_TemplateForSetupEdit.dat" -E -n -T -S localhost

Here is the BCP output:

Warning: Ignoring 'E' flag when copying out.
Password:
CTLIB Message:  - L1/O1/S1/N138/1/0:
in, CA 94568, USA"
: user api layer: external error: A data length of 255 exceeds the maximum length allowed for password data.
Setting connection properties failed.

Here is the Regex string being looked for: [0-9]+\srows copied

Using BCP to get data from table [dbo].[ScansMain]
bcp.exe "[ForWebA].[dbo].[ScansMain]" out "c:\SQLAzureMW\BCPData\dbo.ScansMain.dat" -E -n -T -S localhost
*


Thanks

0
Comment
Question by:joygomez
1 Comment
 
LVL 4

Accepted Solution

by:
qasim_md earned 2000 total points
ID: 35503256
Try to replace it with the following and let me know if it worked ????

BCP "select * from [ForWebA].[dbo].[SampleTypeIndicies_TemplateForSetupEdit]" queryout "c:\SQLAzureMW\BCPData\dbo.SampleTypeIndicies_TemplateForSetupEdit.dat" -E -n -T -S localhost
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Optimized for private cloud infrastructures and datacenters, Nano Server is minimalistic, yet super-efficient, OS for services such as Hyper-V and Hyper-V cluster. Learn how you can easily deploy Nano Server and unlock its power!
On Feb. 28, Amazon’s Simple Storage Service (S3) went down after an employee issued the wrong command during a debugging exercise. Among those affected were big names like Netflix, Spotify and Expedia.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

868 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question