Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want one server to migrate the database to another server. On another server database already exists, then ist all the tables, but they are empty and I want to fill. For the filling, I want to use bcp - database migration. In command line, I wrote the following:

bcp [dbo].[aspnet_Profile] in "c:\SQLAzureMW\BCPData\dbo.aspnet_Profile.dat" -E -n -b 10000 -a 16384 -S -U username@servername -P "password" -d databasename!

The name of the user and the server name passvord written correctly.

When I run I get this error: enter image description here error = Packet size change not supported by server, default used.

Then I fixed packet size to the size of a default. I removed the "-a".

bcp [dbo].[aspnet_Profile] in "c:\SQLAzureMW\BCPData\dbo.aspnet_Profile.dat" -E -n -b 10000 -S -U username@servername -P "password" -d databasename!

Then I got the following error: enter image description here

Who can tell what I should do, or is there a good way to move the database? I also used the SQL Azure Migration Wizard,but it don't help me.

share|improve this question

migrated from Dec 28 '11 at 14:23

This question came from our site for professional and enthusiast programmers.

Was this a better fit back on Stack Overflow being about Azure and all? – jcolebrand Dec 31 '11 at 1:54

I found the reason that did not work, and really was not password correct because I used the password to these characters who divided password to pieces, and of that reason but it was not correct. I used to password ",", "$" and other characters.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.