|
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
|