General Error 2147217891 (8004E1D) export to mysql

Hello I am trying to export a large table from mssql to mysql using the mysql driver.
I am using the wizard in the enterprise manger for mssql. I can export small tables but not large tables apparently.
I have checked permissions.

OS: win 2k3 enterprise edition.
MSSQL2000 SP3
to
WinXP
Mysql 5.0.51b
LVL 1
krv123Asked:
Who is Participating?
 
Nathan RileyConnect With a Mentor FounderCommented:
0
 
krv123Author Commented:
So its an issue mapping column types?
0
 
Nathan RileyFounderCommented:
Yes, it looks like you may have issues with a type of column that isn't supported in the other DB
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
krv123Author Commented:
Ok I will take a look.
0
 
krv123Author Commented:
This is the sql script from mssql anything look incompatible if was in mysql?
CREATE TABLE [dbo].[AR4_OpenInvoice] (
	[Division] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomerNumber] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[InvoiceNumber] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[InvoiceType] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[InvoiceDate] [datetime] NULL ,
	[InvoiceDueDate] [datetime] NULL ,
	[InvoiceDiscountDate] [datetime] NULL ,
	[TermsCode] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[TaxSchedule] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[SalespersonCode] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[SplitCommissionFlag] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[PostingDate] [datetime] NULL ,
	[Comment] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CreditMemoInvoiceRef] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[JobNumber] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CustomerPONumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[PostRefCheckNumber] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[CommissionRate] [decimal](19, 7) NULL ,
	[TaxableAmount] [decimal](19, 7) NULL ,
	[NonTaxableAmount] [decimal](19, 7) NULL ,
	[Freight] [decimal](19, 7) NULL ,
	[SalesTaxAmount] [decimal](19, 7) NULL ,
	[CostOfSales] [decimal](19, 7) NULL ,
	[SalesSubjectToComm] [decimal](19, 7) NULL ,
	[CostSubjectToComm] [decimal](19, 7) NULL ,
	[CommissionAmount] [decimal](19, 7) NULL ,
	[DiscountAmount] [decimal](19, 7) NULL ,
	[PaymentsToday] [decimal](19, 7) NULL ,
	[Balance] [decimal](19, 7) NULL ,
	[RetentionAmount] [decimal](19, 7) NULL 
) ON [PRIMARY]
GO

Open in new window

0
 
krv123Author Commented:
Conversion types for mysql from mssql

what do these = in mysql?

long varbinary
numeric
0
 
Nathan RileyConnect With a Mentor FounderCommented:
long varbinary = MEDIUMBLOB
numeric = DECIMAL
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.