Cureless - blog, works and personal site of Yoru

Cureless

Cureless is the online journal (blog) of Yoru, a Filipina, programmer, ex-military, an anime otaku, a casual DoTA and MMORPG gamer and a self-proclaimed artist - in short, a geeky nerd and a fan.
Take a peek at her occasional ramblings about random passions and life experiences, browse her archives and works.

email

flickr

2008-philippine-toycon-Ultraman2008-philippine-toycon-992008-philippine-toycon-982008-philippine-toycon-97

Overtime on SQL and stuff

I ain't gonna let this moment pass... Anyways, I'm here on overtime. I just washed my laundry back in our barracks and... I went back here to polish my techblog over here. Now it's time to use it FOR REAL 'cause it's required by teh boss...

-

Our task for the week is to migrate several MSQL (Microsoft SQL) database tables to PostgreSQL. The task isn't so daunting considering there are 6 of us working on the migration. I just haven't figured out yet how PostgreSQL seem to alter the tables' datatype when importing the created views in MSQL...

So far, my workmate's plan is to import them all first to MySQL and port them later to PostgreSQL. It'd be easier to do the migration in this manner since the DB manager we're using can handle both MySQL & PostgreSQL.

I've already created views for some of the tables I was assigned to handle. Thanks to the DBToolsManager wizard. I don't have to create SQL statements anymore.

Download FREE WordPress Themes

Download FREE WordPress Themes

Sponsored Links

  • Hire Me via PayPerPost Direct!