joygomez
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].[SampleTy peIndicies _TemplateF orSetupEdi t]" out "c:\SQLAzureMW\BCPData\dbo .SampleTyp eIndicies_ TemplateFo rSetupEdit .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].[ScansMai n]" out "c:\SQLAzureMW\BCPData\dbo .ScansMain .dat" -E -n -T -S localhost
*
Thanks
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].[SampleTy
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].[ScansMai
*
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.