How to export the schema and the data of an MSSQL-DB into an .sql script

One way to make a back-up file of your MSSQL Database is by exporting its schema, and optionally its data, into a new .sql script. The script can be automatically generated via the MSSQL Management Studio tool. Here is how:

Read the complete article

How to rename a column in an MSSQL temporal table

Temporal tables is a neat feature that allows us to version the data of our MSSQL-tables so that we keep a history of changes made. The renaming of columns of a table which is backed up by a temporal table is not 100% straightforward since you do not get the “Design” option when you right click on the table in SQL Management Studio. To perform the renaming, do the following steps:

Read the complete article

Copy all rows from one table to another new table in MSSQL

When you want to create a new table in a Database B and fill it with the rows of another table in Database A, then you can use the SELECT … INTO format like in the following query:

Read the complete article

Connect to an MSSQL Database running on a Docker Container

Running an MSSQL Database inside a Linux Docker Container can be done for many reasons. You might want to host your dockerize your whole web application or even the DB part of it. When using such a Container you want to have an easy way to see the content of the Database. For that we can use the SQL Server Management Studio tool.

Read the complete article

How to solve the "ERROR [IM002] [unixODBC][Driver Manager]Data source name not found and no default driver specified" error when setting up an ODBC connection

Lately I was setting up a web application inside a Docker. container which communicates via ODBC with a database. In order to be able to query the database, I had to add the name of the database and the credentials into the odbc.ini and odbcinst.ini files. My queries were failing with the following message: “ERROR [IM002] [unixODBC][Driver Manager]Data source name not found and no default driver specified”

Read the complete article