Getting the error java.sql.SQLException: Invalid object name 'STATION_NAME.dbo.sysobjects'. when attempting the convert a Cloudscape database to SQL 2005 in the Niagara R2 console window.

Issue

Getting the following error when attempting the convert a Cloudscape database to SQL 2005 in the Niagara R2 console window:

  java.sql.SQLException: Invalid object name STATION_NAME.dbo.sysobjects'.

        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)

        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)

        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)

        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)

        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777)

        at tridium.util.MSSqlServer.doesTableExist(MSSqlServer.java:341)

        at tridium.util.MSSqlServer.checkTableWithKey(MSSqlServer.java:316)

        at tridium.datax.sql.DxSqlUtil.checkTableWithKey(DxSqlUtil.java:190)

        at tridium.datax.sql.DxSqlUtil.checkTable(DxSqlUtil.java:173)

        at tridium.tools.DbAdmin.migrateData(DbAdmin.java:1007)

        at tridium.tools.DbAdmin.main(DbAdmin.java:198)

        at tridium.tools.DbAdmin.main(DbAdmin.java:122)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at tridium.nre.Nre.mainImpl(Nre.java:663)

        at tridium.nre.Nre.main(Nre.java:603)

Product Line

TAC I/A Series

Environment

Niagara R2, WorkPlace Pro version 529 and higher, Windows SQL 2005

Cause

The Enterprise Server and SQL 2005 database names do not match. The Enterprise Server and SQL 2005 database names have to be the same when migrating the Cloudscape database to a SQL 2005 database.

Resolution

Rename either the Enterprise Server station or SQL Server database so that the names are the same. Once the names are the same, the migration should go without issues.