[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

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
0
krv123
Asked:
krv123
  • 4
  • 3
2 Solutions
 
Nathan RileyFounder/CTOCommented:
0
 
krv123Author Commented:
So its an issue mapping column types?
0
 
Nathan RileyFounder/CTOCommented:
Yes, it looks like you may have issues with a type of column that isn't supported in the other DB
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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 RileyFounder/CTOCommented:
long varbinary = MEDIUMBLOB
numeric = DECIMAL
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now