No data of DB is transferred to SQL Azure

Aug 6, 2012 at 3:46 PM

Hello!

I'm trying to transfer data from your program from the MS SQL 2008 R2 SP1 in SQL Azure information. In the directory C: \SQLAzureMW\BCPData create files *.dat. But the data is not imported into the SQL Azure. Encoding database Cyrillic_General_CI_AS.

Coordinator
Aug 6, 2012 at 5:02 PM

Hi,

What kind of error are you getting?

Thanks,
George

Aug 6, 2012 at 5:10 PM

I do not get any errors. The display only text:

Process started at 06.08.2012 21:51:15 -- UTC -> 06.08.2012 15:51:15 ... 

Processing finished at 06.08.2012 21:51:15 -- UTC -> 06.08.2012 15:51:15

Total processing time: 0 hours, 0 minutes and 0 seconds

Aug 6, 2012 at 5:14 PM

Maybe somewhere else to look out the error log?

Coordinator
Aug 6, 2012 at 6:15 PM


Hi,

 

When you export your source database, you should see two tabs on the Results Summary page.  On the Result Summary tab, you should see BCP output and any flags that you might need to address before migration.  It would look something like this:

 

Process started at 8/6/2012 11:49:48 AM -- UTC -> 8/6/2012 4:49:48 PM ...

Using BCP to get data from table [dbo].[Order Details]

bcp.exe "[Northwind].[dbo].[Order Details]" out "c:\SQLAzureMW\BCPData\dbo.Order Details.dat" -E -n -T -S localhost

*

Starting copy...

1000 rows successfully bulk-copied to host-file. Total received: 1000

1000 rows successfully bulk-copied to host-file. Total received: 2000

2155 rows copied.

Network packet size (bytes): 4096

Clock Time (ms.) Total     : 16     Average : (134687.50 rows per sec.)

 

BCP output file: "c:\SQLAzureMW\BCPData\dbo.Order Details.dat"

 

Changing index [dbo].[Region].PK_Region to a clustered index.  You may want to pick a different index to cluster on.

 

Summary of BCP output commands

bcp.exe "[Northwind].[dbo].[Order Details]" out "c:\SQLAzureMW\BCPData\dbo.Order Details.dat" -E -n -T -S localhost

bcp.exe "[Northwind].[dbo].[Region]" out "c:\SQLAzureMW\BCPData\dbo.Region.dat" -E -n -T -S localhost

Analysis completed at 8/6/2012 11:50:03 AM -- UTC -> 8/6/2012 4:50:03 PM

Any issues discovered will be reported above.

Total processing time: 0 hours, 0 minutes and 5 seconds

 

On the SQL Script tab, you should see the TSQL that will be run against your target database.  Please validate that you see something on this page.  Mine looks something like this:

 

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Order Details]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[Order Details](

            [OrderID] [int] NOT NULL,

            [ProductID] [int] NOT NULL,

            [UnitPrice] [money] NOT NULL,

            [Quantity] [smallint] NOT NULL,

            [Discount] [real] NOT NULL,

 CONSTRAINT [PK_Order_Details] PRIMARY KEY CLUSTERED

(

            [OrderID] ASC,

            [ProductID] ASC

)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)

)

END

 

IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Order Details]') AND name = N'OrderID')

CREATE NONCLUSTERED INDEX [OrderID] ON [dbo].[Order Details]

(

            [OrderID] ASC

)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF)

GO

BCPArgs:830:[dbo].[Orders] in "c:\SQLAzureMW\BCPData\dbo.Orders.dat" -E -n -b 10000 -a 16384

GO

-- BCPArgs:2155:[dbo].[Order Details] in "c:\SQLAzureMW\BCPData\dbo.Order Details.dat" -E -n -b 10000 -a 16384

GO

 

You should see the TSQL and the BCP args that will be used for the upload process.  Now, if you see all of that, then when you hit next, you will be asked to enter your target server information.  Once you connect to your target server, create the database and then hit next.  You will be asked if you are sure you want to execute script against destination server.  Select yes and the TSQL should be run against your target server.  You will see a “Target Server Response” page with a “Results” tab.  In that tab you should see output response and BCP upload commands.  For example mine looks like this:

 

Process started at 8/6/2012 12:06:32 PM -- UTC -> 8/6/2012 5:06:32 PM ...

-- Success: CREATE TABLE [dbo].[Order Details](

 -- Success: ALTER TABLE [dbo].[Order Details]  WITH NOCHECK ADD  CONSTRAINT [FK_Or

 -- Success: ALTER TABLE [dbo].[Order Details] CHECK CONSTRAINT [FK_Order_Details_O

 -- Success: ALTER TABLE [dbo].[Order Details]  WITH NOCHECK ADD  CONSTRAINT [FK_Or

 -- Success: ALTER TABLE [dbo].[Order Details] CHECK CONSTRAINT [FK_Order_Details_P

 -- Success: ALTER TABLE [dbo].[Order Details]  WITH NOCHECK ADD  CONSTRAINT [CK_Di

 -- Success: ALTER TABLE [dbo].[Order Details] CHECK CONSTRAINT [CK_Discount]

 -- Success: ALTER TABLE [dbo].[Order Details]  WITH NOCHECK ADD  CONSTRAINT [CK_Qu

 -- Success: ALTER TABLE [dbo].[Order Details] CHECK CONSTRAINT [CK_Quantity]

 -- Success: ALTER TABLE [dbo].[Order Details]  WITH NOCHECK ADD  CONSTRAINT [CK_Un

 -- Success: ALTER TABLE [dbo].[Order Details] CHECK CONSTRAINT [CK_UnitPrice]

 -- Success: ALTER TABLE [dbo].[Order Details] ADD  CONSTRAINT [DF_Order_Details_Un

 -- Success: ALTER TABLE [dbo].[Order Details] ADD  CONSTRAINT [DF_Order_Details_Qu

 -- Success: ALTER TABLE [dbo].[Order Details] ADD  CONSTRAINT [DF_Order_Details_Di

 -- Success: CREATE PROCEDURE CustOrderHist @CustomerID nchar(5)

 -- Success: CREATE PROCEDURE CustOrdersDetail @OrderID int

 -- Success: CREATE PROCEDURE CustOrdersOrders @CustomerID nchar(5)

 -- Success: create view "Order Subtotals" AS

 -- Success: create procedure "Employee Sales by Country"

 

8/6/2012 12:06:43 PM

8/6/2012 12:06:43 PM

 --> Uploading data to Order Details

 --> BCP Command: bcp.exe "Bubba.dbo.Order Details" in "c:\SQLAzureMW\BCPData\dbo.Order Details.dat" -E -n -b 10000 -a 16384 -q -S j7d9769xtb.database.windows.net -U "sa@ j7d9769xtb " -P xxxxx

**

8/6/2012 12:06:44 PM --> Copied 2155 of 2155 (100%)

Clock Time (ms.) Total     : 1045   Average : (2062.20 rows per sec.)

 

8/6/2012 12:06:44 PM

 --> Uploading data to Region

 --> BCP Command: bcp.exe "Bubba.dbo.Region" in "c:\SQLAzureMW\BCPData\dbo.Region.dat" -E -n -b 10000 -a 16384 -q -S j7d9769xtb.database.windows.net -U "sa@ j7d9769xtb " -P xxxxx

*

8/6/2012 12:06:45 PM --> Copied 4 of 4 (100%)

Clock Time (ms.) Total     : 125    Average : (32.00 rows per sec.)

Processing finished at 8/6/2012 12:06:45 PM -- UTC -> 8/6/2012 5:06:45 PM

Total processing time: 0 hours, 0 minutes and 6 seconds

 

From your example, where you had nothing between Process started and Processing finished, it looks like there was no TSQL.  If you want, contact me offline via codeplex (click on my name) and we can work on figuring out what is happening.

 

Regards,

George

Aug 6, 2012 at 7:12 PM

When I export my source database, I  see  TSQL + BCP-code. However, when she is unloading only see the TSQL.

p.s. Data are uploaded directly via bcp - works :) (tables and relationships are not very many)

Coordinator
Aug 6, 2012 at 7:27 PM

Can you contact me via codeplex?  I would like to see the TSQL script if possible.  Also, if you bring up a command window and type "BCP -v", do you see "Version: 10.50.1600.1"?

Aug 7, 2012 at 2:57 AM

BCP version  10.50.2500.0.

I will send TSQL later