Does exist some software for transforming data from one DB schema to another?

See more:

SQL

database

data

transform

schema

, +

I need to transform between two different database schemas the same data. For example i have one table in old schema looking like this:

OLD EMPLOYEE TABLE
USER_ID - NUMBER (PRIMARY KEY)
FIRST_NAME - VARCHAR(50), (NOT NULL)
LAST_NAME - VARCHAR(50), (NOT NULL)
CITY - VARCHAR(50), (NOT NULL)

and i need to transform it to new tables like these:

NEW EMPLOYEE TABLE
USER_ID - NUMBER (PRIMARY KEY)
FIRST_NAME - VARCHAR(50), (NOT NULL)
LAST_NAME - VARCHAR(50), (NOT NULL)
CITY_ID - NUMBER, (NOT NULL, FOREIGN KEY)

NEW CITY TABLE
CITY_ID - NUMBER (PRIMARY KEY)
CITY_NAME - VARCHAR(50), (NOT NULL)

So I have two questions to ask:

1. Does exist software that can migrate data between these two schemas (Without or with little usage of SQL)?
2. If it exist, can this software migrate even between two platforms (I.e. MSSQL to Oracle)?

Thanks!

What I have tried:

I've tried to find some utility like this but without success.