Creating MSDE Repository with EA Scripts

[bioform]

I'm running EA 5.0 build 772 on my laptop with MSDE 2000 installed. I downloaded the EA script for building the repository, but just don't know how to get the script into an Access Project to execute?

Kind of a newbie at this...

Thanks in advance for any help!

[thomaskilian]

Scripts are only needed for SQL Server (MySQL, Oracle, etc.). If you're running native EAP you don't need MS Access tools. Just open an EAP by double click and EA will handle it.

[bioform]

I'm sorry I must not have been clear. I want to "CREATE" a SQL database that will become the repository of the EA project (the RDMS I will be using is Win SQL Server 2000 desktop edition: MSDE)

I was trying to understand HOW to exexute the EA supplied SQL script to create the database files...

[thomaskilian]

And what's the relation to the Access Project? Your question is stil unclear :-/

[sargasso]

The script is for MS-SQL.  It is intended to be run in MSSQL not in Access.  Since IIRC, MSDE does not give you a GUI SQL script "runner" you have to either
a) use the command line MSSQL script runner, which I have always held to be dog, or
b) disassemble the script into single DDL queries and run each one from within MS-Access.

(Alternate strategies are:
a) get a full MS-SQL license
b) investigate postgres   )

bruce

[hd]

If you don't have access to MSSQL Query Analyzer, you could try SQL Buddy - and it's free...

http://sqlbuddy.sourceforge.net/