I am having an issue with EDG not picking up all of the tables in my DDL file. Imports with no errors, but when I verify table counts, EDG always leave out 3 tables that are in the DDL File.
On Thursday, September 8, 2022 at 2:09:25 PM UTC-6 Tim Smith wrote: > Thanks John! I changed the encoding to UTF-8 in Notepad++ and it worked > perfectly. > > [image: image.png] > > On Thu, Sep 8, 2022 at 3:57 PM John Beard <[email protected]> wrote: > >> Hi Tim, >> >> The problem is what is called a *byte order mark* in your file. Here is >> some explanation, >> https://stackoverflow.com/questions/43821212/sql-server-management-studio-saves-sql-file-with-binary-character >> . >> >> This will be fixed in EDG 7.4.0. But for now you can fix it when you >> save the file from management studio. Or you can just open the file in >> notepad and then change the encoding when you save it. I recommend just >> using UTF-8, without BOM. >> >> On Wednesday, September 7, 2022 at 4:15:24 PM UTC-4 Tim Smith wrote: >> >>> Hi, >>> >>> EDG Studio 7.3 >>> >>> I am attempting to import a DDL file generated by SSMS (SQL Server). >>> Using the import wizard, I select the type of DDL and give it a database >>> name. The only triples created are those for an instance of Physical Data >>> Model and Relational Database. Everything in the file is ignored. >>> >>> To debug, I stripped the file down to a single create table statement >>> (see below). Even that is ignored. I cannot even be sure EDG is actually >>> reading the file. There are no console/log messages. No visible errors of >>> any kind. >>> >>> What should I try next? >>> >>> Thanks, >>> >>> Tim >>> >>> >>> [image: image.png] >>> >>> >>> >>> CREATE TABLE [dbo].[MY_TABLE]( >>> [PK] [nvarchar](255) NOT NULL, >>> [EXCLUDE_PICKING] [bit] NOT NULL, >>> [REPLENISHMENT_ACCESS] [bit] NOT NULL, >>> [DESTINATION_AREA] [nvarchar](255) NOT NULL, >>> [DESTINATION_LOAD_UNIT_TYPE] [nvarchar](30) NOT NULL, >>> [SOURCE_AREA] [nvarchar](255) NOT NULL, >>> [SOURCE_LOAD_UNIT_TYPE] [nvarchar](30) NOT NULL, >>> [UNPACKING_ZONE] [nvarchar](40) NULL, >>> [CREATE_DATE] [datetime2](7) NULL, >>> [CREATE_USER] [nvarchar](255) NULL, >>> [MOD_DATE] [datetime2](7) NULL, >>> [MOD_USER] [nvarchar](255) NULL, >>> [VERSION] [bigint] NOT NULL, >>> CONSTRAINT [PK_W_AREA_ACCESS] PRIMARY KEY CLUSTERED >>> ( >>> [PK] ASC >>> )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = >>> OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] >>> ) ON [PRIMARY] >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "TopBraid Suite Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/topbraid-users/d4aa2b3e-59ca-41be-9e39-c14554d21936n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/topbraid-users/d4aa2b3e-59ca-41be-9e39-c14554d21936n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/8afba6f0-8ff8-4932-a0df-fbe53a3db46an%40googlegroups.com.
