Articles #Jehy

If you need drop too many tables to do it manually, you can use query like this:

select ‘drop table ‘||table_name||’;’ from all_tables where table_name like ‘T_%’;

It will create SQL queries. You can edit them and them run to delete all you want.

Hello, everyone. I just finished this hellish task.
I hope it will be useful for someone, and I don’t want to forget it myself :)

In this article I will show how to
1) Import .mdf file to MS SQL
2) Export from MS SQL 2008 to MS SQL 2005
3) Export from MS SQL 2005 to Oracle.

Several little warnings. Those are not obvious because oracle & Microsoft don’t boast about it – I wasted much time to find it out.

1) You can’t export directly from MS SQL 2008 to Oracle.
2) You can’t export directly .mdf file to Oracle.
3) MS SQL 2005 Express Edition works on Windows XP 2. Full version doesn’t.
4) MS SQL Management Studio can do export to Oracle. Theoretically. On practice, it can’t.

So, let’s begin.

Continue reading…