SQL Scripts SQL Server and MSDE

Before Enterprise Architect can be configured to use SQL Server as a Repository the following Software Components need to be installed and configured:

  • MDAC 2.6 or 2.7
  • Install SQL Server.

Once these preconditions have been met the following process should be used to create the Enterprise Architect SQL Server repository:

  1. Create an empty database.
    Note: The database collation should be a case-insenstive collation.
  2. Using a tool such as the SQL Query Analyzer, load the SQLServer_EASchema.sql file, ensuring that the new database is selected as the current database.
  3. Run the script to create all of the required tables /indexs etc.
  4. With the empty database you can now use the data transfer tool to transfer an existing model to the server. Before doing so however, you should run the Project Integrity tool, to ensure the data is 'clean' before uploading. You can do this by opening the existing model in Enterprise Architect and selecting Tools | Data Management | Project Integrity Check.
  5. To proceed with the transfer:
    • Open Enterprise Architect and then select Tools | Data Management | Project Transfer.
    • In the Dialog provided select .EAP to DBMS.
    • For the fields:
      • Source Model: Select the .EAP file that you want to transfer into the SQL Server repository.
      • Target Model:
        • Select the "Microsoft OLE DB Provider for SQL Server". Then press the Next button.
        • On the data Source Details page of the connections dialog. Enter the server name, database name and security details as required.
    • Press the OK button. When the dialog appears prompting for the name and connection type, ensure that SQL Server is selected. The name is not required.
    • Press the Transfer Data button, this will begin the process.
    • Once this process completes, the contents of the .EAP model now exists on the SQL Server repository and you may open the repository from Enterprise Architect, using the "Connect to Server" option.