1
Vote

Only schema is getting copied and no data

description

I am trying to copy the sql azure database to sql server. I tried sql server 2008 R2 and sql sever 2012. This utility only copies the schema over but not data. Is this a bug being worked on or I am missing something.

Thanks for this utility.. :)

comments

ghuey wrote Dec 16, 2012 at 3:34 AM

Hi,

You should see a couple of things. 1) when you export your database, you should see a BCP summary at the bottom of the script. So, is that there? 2) If you look at the output directory, you should see a bunch of .dat files. Are they there? When you import into SQL Database, you should see multiple tabs showing BCP uploading data and the BCP output should be in the main results window. Do you see anything there? You need to be sure that you are running SQL Server 2008 R2 SP1 and that when you do BCP /v from a command prompt that BCP version is 10.50 or greater. If you want, you can contact me offline.

Regards,
George

Sign in to add a comment or to set email notifications