Comments
Sort by recent activity
I like highlighting a row in the SSMS results and saying "Script as Insert" to automatically create an insert script for me. Super handy when I need to move that data over somewhere else (i.e. from my local Docker database into a migration script in Flyway). / comments
I like highlighting a row in the SSMS results and saying "Script as Insert" to automatically create an insert script for me. Super handy when I need to move that data over somewhere else (i.e. from...
I’ll be there! I have a few clients on Flyway (with both Postgres and MSSQL but Postgres being the new default for new apps) and one on SCA (MSSQL) right now. Some questions I have about Deploy are: - When do I pick this over Flyway or SCA? Or re-phrased, what are the tradeoffs? - If a client is on either Flyway or SCA, what’s the sales pitch for getting them to consider Deploy? Should they be? - Is there one product Redgate is investing in more heavily and possibly reducing investment in another? - Is there a table or comparison chart that gives a rundown of features and what is available in which product? Thanks! Looking forward to learning more. / comments
I’ll be there! I have a few clients on Flyway (with both Postgres and MSSQL but Postgres being the new default for new apps) and one on SCA (MSSQL) right now.Some questions I have about Deploy are:...
I'm in! / comments
I'm in!
Something I find handy with SQL Prompt is the "Script as Insert" feature. When you get the results back from running a query, you can highlight the entire data set (or just the rows you care about), then right-click and choose "Script as Insert." This will scaffold out the insert statement for you inside of SSMS. This is handy for scenarios such as generating a script to be used for re-seeding data for an integration test without having to write that insert by hand. / comments
Something I find handy with SQL Prompt is the "Script as Insert" feature. When you get the results back from running a query, you can highlight the entire data set (or just the rows you care about...