Populate zone from T-SQL

[TimothyK]

Thanks, great tool! Its simple enough to use. Run the script to create the empty tables, then run the program that connects to the internet and insert/update those tables.

Would it be possible to post here a version of the T-SQL script that not only creates the empty tables, but also populates them with the latest IANA database?

This would avoid having to run a program or have an internet connection. Then it is just once a year (or whatever schedule you want) grab that T-SQL script can give it to your DBA to run. That may be more acceptable to some DBAs over installing a program to run periodically.

Are there others out there that have to run this tool on their machines then create an export script to hand it off to DBA(s)? If so maybe this step could be crowd sourced / open sourced and posted on the Releases page here.

[mbtaylor1982]

I had a look at creating this script and it is massive due to the amount of records in the intervals table :/

I have written my own tool in Delphi to populate the intervals using data directly from the IANA TZDB as the application i work on has a 'no .net dependencies' stipulation.

[martincheck]

@TimothyK I like this idea, it's much easier to convince a DBA to run a giant script than to run an executable. Would it make sense to have a "BCP" option, where the data for each table is in a flat file, and you can run a BCP command to load the data in? That way the DBA can see exactly what is going into the database before it runs.

Implementation as I see it would be to have the "SQLtzloader" command have a "BCP" output option, where it will dump a file that can be BCP'd in and generate the BCP scripts, instead of loading the data directly. The files can then be reviewed and executed by the DBA.

[derobuts]

am getting an error 'Zone interval extends to the beginning of time'

[derobuts]

this line
var intervals = tzdb[id].GetZoneIntervals(Instant.MinValue, maxInstant);
foreach (var interval in intervals)
{

                    var utcStart = interval.Start == Instant.MinValue
                        ? DateTime.MinValue
                        : interval.Start.ToDateTimeUtc();