Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - hd

Pages: 1 ... 16 17 [18] 19 20 21
256
General Board / Re: Import schema for an ACCESS mdb
« on: August 19, 2003, 11:36:30 pm »
Thanks for your feedback.  ;) We are reviewing the help file for the release of version 3.60, which is currently available to registered users for beta testing.

The existing help file | Using UML | Data Modelling | Reverse Engineer ODBC data sources - contains the steps you require.

You need to enable JET 4.0 for Access database greater then Access 97. From the menu | View | Options | check the box labelled "Use JET 4.0 - requires restart".

257
General Board / Re: Import schema for an ACCESS mdb
« on: August 18, 2003, 08:36:17 pm »
You need to start with an open diagram, typically Logical View | Data Model | Data Model. Double click this so that a diagram is actually open in the workspace.

Right click on the diagram, select DDL Generation | Import DDL Schema from ODBC.

Click on the button next to the Database Name textbox, and select the ODBC DSN from the Machine Data Source tab. The path to the database will appear in the textbox.

Select the Import button, and a list of available tables will appear. Select tables and click OK to import them.

258
General Board / Re: DDL Script does not consider FKs in DROP stmts
« on: August 03, 2003, 03:40:27 pm »
The order of DDL drop statements is an issue that is currently under review. It will be addressed in a future release of EA.

259
General Board / Re: Problems generating DDL for Oracle 8i
« on: July 31, 2003, 09:47:59 pm »
The data modelling feature of EA is undergoing continuous development. Triggers and sequence/identity columns are on the list of issues that will be addressed in future releases.

260
General Board / Re: XP Home
« on: July 21, 2003, 03:54:56 pm »
You need to download the Oracle 9i client from Oracle.

http://otn.oracle.com/software/products/oracle9i/content.html

This will include the Oracle Provider for OLE DB. nce the client is installed, connect to the Oracle db using this provider.

261
General Board / Re: Generating DDL
« on: July 15, 2003, 03:45:13 pm »
Just to let you know, we are currently improving foreign key creation, DDL import and generation and other aspects of the data modeling feature.

We expect to have some major changes in the next release (3.60) of  EA.

262
General Board / Re: Reference data for SQL server 2000
« on: July 16, 2003, 03:35:09 pm »
The latest build 618 of EA includes SQL Server 2000 datatypes plus a number of other DB datatypes.

263
General Board / Re: Using only SQL Server, not *.eap files?
« on: July 06, 2003, 03:46:18 pm »
You can indeed continue to use just SQL Server as the repository. There is no need to revert to the EAP files. :)

264
General Board / Re: Logical datatypes - how to have 1 model for N
« on: June 25, 2003, 04:09:29 pm »
Datatype mapping between DBMS's is not currently available, but is on our list to include in a future release of EA. :)

265
General Board / Re: Stored Procedure Parameters
« on: June 19, 2003, 04:47:02 pm »
Improvements to database support (DDL import/export) will be rolled out from time to time. The next release should include generation of SQL Server table and column comments using the sp_addextendedproperty syntax, among other things.

Here's a workaround for generating non_parameter stored procedures...

1. Add a table(s) to a package, and select a target database.
2. Add an operation and give it the name of the stored procedure.
3. Select 'proc' from the stereotype combo.
4. Put the body of the procedure in the Notes section of the dialog. Save.
5. Right click on the package and select Code Engineering->Generate DDL.
6. Check 'Create Primary/Foreign Key Constraints' and 'Generate Stored Procedures'.
7. Generate the procedures.

We are developing generation of stored procedures with non-column parameters for a future release.




266
General Board / Re: Modelling Oracle Stored Procedures
« on: June 18, 2003, 08:55:42 pm »
Stored procedures are currently only generated when attached to a table.
However, you can add stored procedures to a package with the following steps...

1. Add a table(s) to a package, and select a target database.
2. Add an operation and give it the name of the stored procedure.
3. Select 'proc' from the stereotype combo.
4. Put the body of the procedure in the Notes section of the dialog. Save.
5. Right click on the package and select Code Engineering->Generate DDL.
6. Check 'Create Primary/Foreign Key Constraints' and 'Generate Stored Procedures'.
7. Generate the procedures.

Hope this helps.



267
Bugs and Issues / Re: EA11 - Generating Triggers DDL
« on: April 02, 2015, 08:15:44 am »
With EA version 12, you can modify the DDL Generation template to add the owner name to the table name.

Open the DDL Template editor from menu Package | Database Engineering | Edit DDL Templates...

Select Language: Oracle, then select the DDL Column Extras template. In the CREATE TRIGGER statement near the bottom of the template, change the line ...

Code: [Select]
$trigger += "      ON " + $tableName + " \n"to ...

Code: [Select]
$trigger += "      ON " + $owner + "." + $tableName + " \n"

268
Bugs and Issues / Re: MySQL ODBC - OLE DB Provider  [-2147217900]
« on: January 09, 2015, 07:38:31 am »
... or upgrade to the current build of EA. The MySQL Partition issue was fixed in build 1009.

269
Bugs and Issues / Re: t_objectresource.resource issue
« on: April 15, 2014, 07:42:05 am »
Resource is an Oracle keyword. Wrap it in double quotes...

Code: [Select]
SELECT  "Resource" FROM t_objectresource

270
Bugs and Issues / Re: MySQL ODBC driver problems - Solution
« on: April 05, 2013, 07:46:30 am »
MySQL ODBC 5.1.12 works fine for me, on a 5.1.52 community server.

Have you set the 2 options listed in item 7 on page...
http://www.sparxsystems.com/enterprise_architect_user_guide/9.3/projects_and_teams/setupmysqlodbcdriver.html

Make sure you have the 32-bit driver installed, and set it up from C:\Windows\SysWOW64\odbcad32.exe

Pages: 1 ... 16 17 [18] 19 20 21