MySQL Forums
Forum List  »  MySQL Workbench

Importing a MS SQL Schema
Posted by: Owen Huffaker
Date: November 12, 2008 05:31PM

I have a pretty simple schema from a MS SQL Server database and I am trying to reverse engineer an ER diagram using the import feature. Following the workbench tutorial, I imported the sakila-schema.sql just fine so I am guessing the product works. When I import, it says it was successful but does not show any tables.

Here is the schema.

CREATE TABLE [dbo].[HEDI_BATCH_DETAIL] (
[HBD_TRADING_PARTNER_NUMBER] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[HBD_BATCH_NUMBER] [char] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[HBD_EDI_TYPE] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[HBD_PRECESS_DATE] [datetime] NULL ,
[HBD_TRANSACTION_COUNT] [int] NULL ,
[HBD_BEGIN_TRANSACTION_DATE] [char] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[HBD_END_TRANSACTION_DATE] [char] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[HEDI_PROCESSED_INVOICES] (
[HPI_BILLTOID] [int] NULL ,
[HPI_BILLTOCUSTCODE] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[HPI_ORDERNUMBER] [char] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[HPI_ORDERDATE] [datetime] NULL ,
[HPI_PROCESSDATE] [datetime] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[HEDI_TRADING_PARTNER_MASTER] (
[HTPM_TRADING_PARTNER_NUMBER] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[HTPM_TRADING_PARTNER_NAME] [char] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[test] (
[xxx] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

Options: ReplyQuote


Subject
Views
Written By
Posted
Importing a MS SQL Schema
6660
November 12, 2008 05:31PM
3943
November 14, 2008 10:46AM
2580
May 15, 2009 10:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.