This project is read-only.

Error when connecting to 2005 server.

Feb 5, 2014 at 3:10 AM
Here's the command and error:
$ sqlserverdump --sql-engine --server-name=footserver --username=foouser --p
assword=foopassword --result-file='/c/Backup/foo.sql' FOODB

Unhandled Exception: Microsoft.SqlServer.Management.Smo.UnsupportedVersionExcept
ion: This method or property is accessible only while working against SQL Server
2008 or later.
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.CheckVersion100()
at Microsoft.SqlServer.Management.Smo.Database.get_UserDefinedTableTypes()
at Helvartis.SQLServerDump.Program.run(String[] args)
at Helvar
Is 2005 still supported?

thx!
Feb 7, 2014 at 7:15 AM
I don't have a SQL Server 2005 version to try sqlserverdump against (I have searched for a while but haven't found a working link to download the trial version of SQL Server 2005; I would appreciate if anybody could direct me to a working link...). So it's hard for me to provide support for SQL Server 2005. But when an imcompatibility is reported, I will fix it in a future version as long as the fixes don't become too overwhelming.

That said, you should try the option --no-user-defined-table-types.