Tag Archives: database
Remove CSV text qualifiers within a field using Python
Have you ever tried to import a CSV into a database and found that it won’t load because one of your CSV fields has a text qualifier inside the field itself? In this post I look at how to resolve this issue using a few lines of Python code.
How to forward engineer SQL scripts from Microsoft Visio
Ever wanted to forward engineer a SQL script of DDL statements to automatically generate the tables based on a Visio entity relationship diagram (ERD)? In the steps below, I will explain what you need to do in order to install the Forward Engineer plugin for Microsoft Visio 2010, based on the original work by Alberto Ferrari.