I have started porting our project from SQL Server to Firebird. I thought the best way to do it was to create unit tests on SQL Server, then use the same tests on Firebird. That way I wouldn't have to rewrite the unit tests. I'd just connect to a different data source.
It sounds good in theory, but I've been running into trouble. My first stop was DbUnit. From what we can tell, DbUnit doesn't connect to SQL Server. Is that true? The next logical step was NDBUnit. My colleagues on the Firebird side weren't thrilled with a proprietary solution, but agreed to it if Icould get the job done faster. I've worked all day today trying to get the Firebird data provider integrated with Visual Studio. I've been to http://codemuch.com/node/3, www.firebirdtutorial.net/firebird-data-access-designer-ddex-installation.html, and the DDEX readme. I can't get that data provider to show in Visual Studio. Both DBUnit and NDBUnit rely on an XML file for test data storage. I know this can be generated, but we already have our own XML schema for our test databases. I could probably modify the test framework, but I'm wondering if we could better use a transaction and rollback to keep the database clean. This is what TSQLUnit does. Any comments or suggestions? Steve Miller Language Software Development SIL International ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
