locked
What is correct project type when using the SSMA Console? Getting strange error. RRS feed

  • Question

  • I get this error when attempting to create a project using SSMA Console:

    Server definition 'abc02' has 'sql-server' which is not supported by this connection operation. Please use the correct project-type setting while creating new project.

    I have defined the project-type as sql-server-2005 (as my target is 2005), and it throws this error and leaves very little information in the logs, even on 'debug'.   I tried 2008 as my project type as well as not setting 'project-type'.   Same results with both.     Has anyone run into this before?

    Below is my XML file:

    <?

     

    xml version="1.0" encoding="utf-8"

    ?>

    <

     

    ssma-script-file xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="..\Schemas\O2SSConsoleScriptSchema.xsd"

    >

    <

     

    servers

    >

    <

     

    sql-server name="abc02"

    >

    <

     

    windows-authentication

    >

    <

     

    server value="abc02"

    />

    <

     

    database value="svr_xyz_3"

    />

    <

     

    encrypt value="true"

    />

    <

     

    trust-server-certificate value="true"

    />

    </

     

    windows-authentication

    >

    </

     

    sql-server

    >

     

    <

     

    oracle name="oramig"

    >

    <

     

    standard-mode

    >

    <

     

    connection-provider value ="OracleClient"

    />

    <

     

    host value="abc06"

    />

    <

     

    port value="1521"

    />

    <

     

    instance value="oramig"

    />

    <

     

    user-id value="system"

    />

    <

     

    password value="xyz"

    />

    </

     

    standard-mode

    >

    </

     

    oracle

    >

     

    </

     

    servers

    >

    <

     

    script-commands

    >

    <

     

    create-new-project project-folder="D:\SSMA\xyz

    "

     

     

    project-name="xyz

    "

     

     

    project-type="sql-server-2005

    "

     

     

    overwrite-if-exists="true"

    />

     

    <

     

    connect-source-database server="abc02"

    />

     

    <

     

    connect-target-database server="oramig"

    />

     

    <!--

     

    Save project

    -->

    <

     

    save-project

    />

    <!--

     

    Close project

    -->

    <

     

    close-project

    />

    </

     

    script-commands

    >

    </

     

    ssma-script-file

    >

    Monday, October 17, 2011 6:12 PM

Answers

  • OK, please ignore.   This is apparently the error message one gets when pointing the target to Oracle, and the source to SQL Server.   I guess SSMA doesn't work in reverse.   :-)

    Troy

    • Marked as answer by tel66 Monday, October 17, 2011 7:05 PM
    Monday, October 17, 2011 7:05 PM

All replies

  • Sorry about the messed up formatting above.   Belowis (hopefully) a more readable version.    I should also add that this error occurs just after the connect-source-database call is made.

     

    <?xml version="1.0" encoding="utf-8"?>

    <ssma-script-file xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="..\Schemas\O2SSConsoleScriptSchema.xsd">

      <servers>
        <sql-server name="abc02">
          <windows-authentication>
            <server value="abc02"/>
            <database value="svr_xyz_3"/>
            <encrypt value="true"/>
            <trust-server-certificate value="true"/>
          </windows-authentication>
        </sql-server>


        <oracle name="oramig">
          <standard-mode>
            <connection-provider value ="OracleClient"/>
            <host value="abc06" />
            <port value="1521" />
            <instance value="oramig" />
            <user-id value="system" />
            <password value="xyz"/>
          </standard-mode>
        </oracle>


      </servers>

      <script-commands>

        <create-new-project project-folder="D:\SSMA\xyz"
                            project-name="xyz"
          project-type="sql-server-2005"
                            overwrite-if-exists="true" />


        <connect-source-database server="abc02" />


        <connect-target-database server="oramig" />
       

        <!-- Save project -->
        <save-project />

        <!-- Close project -->
        <close-project />

      </script-commands>
    </ssma-script-file> 

    Monday, October 17, 2011 7:01 PM
  • OK, please ignore.   This is apparently the error message one gets when pointing the target to Oracle, and the source to SQL Server.   I guess SSMA doesn't work in reverse.   :-)

    Troy

    • Marked as answer by tel66 Monday, October 17, 2011 7:05 PM
    Monday, October 17, 2011 7:05 PM