Could not load file or assembly RedGate.SQLCompare.ASTParser

Forum for users of SQL Toolkit 3,4,and 5

Could not load file or assembly RedGate.SQLCompare.ASTParser

Postby jw970170 » Thu Nov 01, 2007 6:05 pm

Hi,

I get this error when I try to RegisterForDataCompare

"Could not load file or assembly 'RedGate.SQLCompare.ASTParser, Version=6.2.0.45, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. The system cannot find the file specified."
Here is my code

dbLocal = new Database();
dbLocal.RegisterForDataCompare(new ConnectionProperties(server, database, username, password));

I even put the file RedGate.SQLCompare.ASTParser.dll in the same directory as the exe but it didn't help with anything.

Any ideas?
jw970170
 
Posts: 12
Joined: Thu Nov 01, 2007 5:11 pm

Postby richardjm » Thu Nov 01, 2007 6:39 pm

This will happen if you use the SQLCompare dlls from the SQL Compare directory and the SQL Data Compare dlls from the SQL Data Compare directory.

Don't mix and match the dlls and it should work ok. i.e. use *only* files from the SQL Compare directory *OR* the SQL Data Compare Directory in a single project.

Yes it's a bit of a faff at the moment and we're looking into ways to improve it.

:)

HTH
Richard Mitchell
Project Manager
Red Gate Software Ltd
richardjm
 
Posts: 506
Joined: Fri May 20, 2005 9:44 am
Location: Red Gate Software Ltd

Postby jw970170 » Thu Nov 01, 2007 7:10 pm

I've re-copied the required dlls from SQL Data Compare directory. They are all from the same directory. I still get the error.

It says the system could not find the file specified....but I'm not supposed to reference the ASTParser.dll. I think I tried with the file referenced as well but it didn't make a difference.
jw970170
 
Posts: 12
Joined: Thu Nov 01, 2007 5:11 pm

Postby jw970170 » Thu Nov 01, 2007 8:49 pm

ok, I didn't realize how many red gate dlls i needed to do the data compare. I hav corrected the issue. I just needed to copy some other dlls to the exe directory

RedGate.SQLCompare.Rewriter.dll
RedGate.SQLCompare.BackupReader.dll
RedGate.BackupReader.dll
jw970170
 
Posts: 12
Joined: Thu Nov 01, 2007 5:11 pm

Postby richardjm » Fri Nov 02, 2007 11:49 am

This is the full list of Red Gate Dlls you need....

* RedGate.BackupReader.CryptoHelper.dll
* RedGate.BackupReader.dll
* RedGate.BackupReader.SqbReader.dll
* RedGate.Shared.Utils.dll
* RedGate.SQL.Shared.dll
* RedGate.SQLCompare.ASTParser.dll
* RedGate.SQLCompare.BackupReader.dll
* RedGate.SQLCompare.Engine.dll
* RedGate.SQLCompare.Rewriter.dll
* RedGate.SQLDataCompare.Engine.dll
* rglz.dll
* System.Data.SQLite.dll
* zlib1.dll

I know it's a lot!
Richard Mitchell
Project Manager
Red Gate Software Ltd
richardjm
 
Posts: 506
Joined: Fri May 20, 2005 9:44 am
Location: Red Gate Software Ltd


Return to SQL Toolkit Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests