I'm feeling pretty good right now. We had an ultra-successful test run of failing all of our #SQLServer instances from the LAX LZ to the OR AZ in AWS. TBH, I just want to be done with all of this because next week we're having a cool onsite, and after that, there's lots of cool work to be done.
I guess my #PowerShell scripts for our #SQLServer migration might be something of a hit. We'll see how they fare with 50-ish failover clusters here in a bit, but the tests with 10 or so were smooth as silk twice earlier today. I know this doesn't sound complicated — it's just failovers amirite? — but there are stumbling blocks that have to be accounted for including network latency, SIOS mirroring, Windows pending reboots, AD, DNS...y'know all of the usual wrenches getting thrown in the gears.
I have an old program I wrote in .NET that pulls data from an old #SQLServer database, exports it to an Excel file then uploads it to a partner via SFTP. I'm trying to re-write it in #python so it is a bit more automated. One step is for it to run a stored procedure, and while the stored procedure does seem to run (can see it in SQL Server Profiler), it doesn't generate the temporary table that later steps require. https://cseiler.freeshell.org/PublicPostGetData.html
1/2 (see thread for updates)
Is there some tool that would allow me to "Describe" a database say with a config file (JSON, YML) and it create the scripts to both create or update an existing DB to match the latest scheme?
Thinking similar to say ruby on rails style ORM but to be a standalone tool for maintaining DBs used by various apps? I do need it to work with MS SQL Server