Link to home
Start Free TrialLog in
Avatar of joygomez
joygomezFlag for United States of America

asked on

SQL azure migration

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

ASKER CERTIFIED SOLUTION
Avatar of qasim_md
qasim_md
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial