Importing SQL Server 2008 datatypes on EA 7.5

[Jorge Dreyer]

Hi, I need import shema from SQL Server 2008. I have used option "Import reference data..." to import new datatypes from SQL Server 2008.
Then, I "import DB shema from ODBC" but some datatypes do not recognize.
What's the exact procedure to work with SQL Server 2008?

I appreciate your help...Thanks for advance.

[«Midnight»]

Which datatypes break?

Are you using the production version of EA 7.5? [Build 843 at this time.]

And when you inspect the imported tables, what DBMS are they set to?

[Jorge Dreyer]

I'm using program version EA 7.5.843 (build:843)... we are registered members.
When I useing data source driver "SQL Server" to ODBC Import... datatypes not recognized are: XML, varchar(max), varbinary(max), nvarchar(max), hierarchyid, geometry, geography.
When I useing data source driver "SQL Server Native Client 10.0" to ODBC Import... datatypes not recognized are: Date, Datetime2, Datetimeoffset, time, geometry, geography.

Imported tables are set to SQL Server 2008 (New product that I imported from XML archive)

[Jorge Dreyer]

Do you need the XML data type that I am importing? How can I send?

[juhi]

Hi,

Could you please send this one as a formal bug report to Sparx Support? The bug report form is available here http://www.sparxsystems.com.au/support/bug_report.html.

  Thanks

Juhi
Sparx Systems Pty Ltd

[«Midnight»]

Jorge,

If you can, I suggest you generate (from SQL Server) a DDL script to create the database and attach that to your bug report.

Remember to compress your attachment files, as this may help if any intervening servers have size or file type limitations.

David

[edit]PS: Please post back and tell the rest of us what transpires. It would be good to know how this gets cleared up.

Thanks,
David[/edit]

[Jorge Dreyer]

The Problem was the driver. The correct driver to Import DB shema from ODBC is "SQL Native Client, version 2005.90...."

Jorge

[«Midnight»]

Thanks Jorge. I had not tried an import of 2005 since the new EA version. I'll verify my driver version.

David