|
Hi Davide,
When you run the wizard, you should come to a results summary page.
On the Results Summary tab, you should see an output something like this:
Using BCP to get data from table [SalesLT].[Customer]
*
Starting copy...
847 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total
: 62 Average : (13661.29 rows per sec.)
BCP output file: "c:\SQLAzureMW\BCPData\SalesLT.Customer.dat"
for each table that has data.
On the SQL Script tab, you should see something like this:
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[SalesLT].[Customer]') AND type in (N'U'))
BEGIN
CREATE TABLE [SalesLT].[Customer](
[CustomerID] [int] IDENTITY(1,1) NOT NULL,
[NameStyle] [dbo].[NameStyle] NOT NULL,
[Title] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FirstName] [dbo].[Name] NOT NULL,
[MiddleName] [dbo].[Name] NULL,
[LastName] [dbo].[Name] NOT NULL,
[Suffix] [nvarchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CompanyName] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SalesPerson] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EmailAddress] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Phone] [dbo].[Phone] NULL,
[PasswordHash] [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PasswordSalt] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[rowguid] [uniqueidentifier] NOT NULL,
[ModifiedDate] [datetime] NOT NULL,
CONSTRAINT [PK_Customer_CustomerID] PRIMARY KEY CLUSTERED
(
[CustomerID] ASC
)WITH (STATISTICS_NORECOMPUTE
= OFF, IGNORE_DUP_KEY = OFF),
CONSTRAINT [AK_Customer_rowguid] UNIQUE NONCLUSTERED
(
[rowguid] ASC
)WITH (STATISTICS_NORECOMPUTE
= OFF, IGNORE_DUP_KEY = OFF)
)
END
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[SalesLT].[Customer]') AND name = N'IX_Customer_EmailAddress')
CREATE NONCLUSTERED INDEX [IX_Customer_EmailAddress] ON [SalesLT].[Customer]
(
[EmailAddress] ASC
)WITH (STATISTICS_NORECOMPUTE
= OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF)
GO
-- BCPArgs:847:[SalesLT].[Customer] in "c:\SQLAzureMW\BCPData\SalesLT.Customer.dat" -E -n -b 10000
GO
The BCPArgs that you see in green above is the command that SQLAzureMWBatch (and SQLAzureMW) looks for to clue it that a BCP execution is required.
Note, that when you step through the wizard, on the “Choose Objects” dialog, there is an “Advanced” button.
Click on that and make sure that you have “Table Schema with Data” selected for “Script Table / Data”.
If you have all that selected (and your table has data), then you should have some kind of output in the Result Summary tab telling you (good are bad) what BCP results were.
The next question for you is are you using an old SQLAzureMW.exe.config file?
I changed how the BCP command is formatted with SQLAzureMW v3.4.1 so you need to make sure that if you are using an old config file that it has the updated commands in it.
If you are getting an error generating the script, send me the exact error message and I will see it I can’t see what is going on.
Another question for you is if you run SQLAzureMW all the way through to deploying to SQL Azure, is you data getting uploaded?
In other words, are you experiencing this issue only with SQLAzureMWBatch?
Thanks,
George
|