Forum Discussion

kirk_bottomley's avatar
12 years ago

Database Determined at Runtime

Alright, I know this must have come up before, but I swear I can't find this topic in any of my searches. I apologize if this is rehashing something already covered.

I need to compare data from SQL databases. I can create the correct data to be compared to in Stores now, while I'm writing the test, with a known SQL database. When the test is run, though, the data structure will be the same but the name of the SQL server will change every time the test is run.

I have logic to retrieve the SQL server name, but I can't find a method to compare the data with the data already in Stores. It wants to connect to the same server I stored the data with and compare the data "now" at runtime to the data I stored when writing the test.

Am I using the wrong method to compare? My idea right now is to create a second server before the test is run, write a test to compare two Stores tables, and copy the data into the second server at runtime, but that seems really inefficient. There has to be a better way.

I have a feeling I'm missing something really basic, and I'm gonna slap myself later, but I can't seem to find it.