TableMappings.Join Must Called With ViewTableSuperClass...

lc6529

I am trying to setup a comparison session with RedGate and Keep Getting the error "TableMappings.Join Must Called With ViewTableSuperClass Arguments"

The error occurs at this line:

oTBLMappings.Join(dSourceDatabase.Views(myReader("tblToCompare").ToString), dTargetDatabase.Tables(myReader("tblToCompare").ToString))

The programming environment is VB 2005 on Windows XP.

I am trying to compare a VIEW of some data to a SQL table that is setup the same way. If anyone could help I would appreciate it!

richardjm

I think I may have worked out what's going on. If both arguments are null I think it gets upset. The accessor you're using in .Views and .Tables requires a fully qualifies table name. You should either use the .Item(string,string) accessor and pass the owner and table name or fully qualify your table name.

Hope this helps.