Closed lcamilo closed 4 years ago
OK cool. I'll look at it tonight and test it out. If you want data, I can dump my db and put it here.
OK cool. I'll look at it tonight and test it out. If you want data, I can dump my db and put it here.
Cool, it could be a good way. If you can export it as INSERTs, I can fix whatever is necessary to import it into my MSSQL database.
Here you go. Zipped up because GitHub wouldn't take sql.
Almost forgot - you need the blocks too. (hm_fwban_rh)
I tested some queries that have enough data and made the necessary corrections, others visually checked and corrected how I know they should work, but it will only be possible to test with certainty when I have more data in the database. If possible, you can test again with MySQL, it may be that some correction I made to work with MSSQL may stop working with MySQL.