358 reputation
28
bio website
location Albany, NY
age
visits member for 3 years, 7 months
seen Dec 12 at 12:38

Database Administrator in upstate New York, where flip flops and a ski jacket is not as uncommon as you'd think..


Feb
17
asked Get Job id OR Job name from within executing job
Feb
17
awarded  Supporter
Feb
16
answered SQL Server 2008 R2 Standard with SSIS Enterprise
Oct
21
awarded  Editor
Oct
21
revised SQL Server: why to use a backup device?
added 87 characters in body
Oct
21
answered SQL Server: why to use a backup device?
Jun
12
awarded  Teacher
Jun
7
comment Tools to migrate from SQLite to PostgreSQL
Thanks! I'm personally more experienced with SSIS, but that comes with SQL Server and you have to pay for the SQL license. Pentaho is an ETL tool and is capable of migrating data from source to destination. You'll need the correct drivers to communicate with the source / destination. There is a bit of a learning curve with any of the ETL tools, but it's another tool in your toolbox, eh? There will be several steps 1 for migrating data, another for migrating DDL changes. I would start with 1 - just move the data(easier step), once you get that down, you will be more comfortable to proceed.
Jun
6
answered Tools to migrate from SQLite to PostgreSQL