MySQL : Development for an Oracle sequence migration

Hi!

Best use Eclipse 3.2 to open the project that is shipped with the tool.

You need to look into the com.mysql.grt.modules package. There you will find a MigrationOracle.java class.

You will need to add 2 functions. First, the actual function that performs the migration (look at migrateViewToMysql() as an example), second a function that returns information about this function (look at getMigrateViewToMysqlInfo()). The second functions needs to be called here.

in

public static MethodList migrationMethods() {
..
methods.add(mig.getMigrateRoutineToMysqlInfo());

return methods;
}


Then your new migration method is available to the tool.

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification

危機管理

• (管理層方面)應該為公司制定完善的風險系統，就是管理學上所講的「PPRR模式」，即是危機管理四個階段的工作：危機前預防 （Prevention）、危機前準備階段（Preparation）、危機爆發期準備（Response）和危機結束期恢復（Recovery），又稱 “MPRR”模式（Mitigation、Preparation、Response、Recovery）。
• 實際上，公司可以有較實際的三個方法︰
• 1. 監察系統。對有機會引起危機的各種因素進行監測，搜集能觸發危機的資訊，以便第一時間掌握事件最新的變化。
• 2. 預測系統。對搜集得來的資料進行分析，以預測可能發生的危機對公司的損害程度。
• 3. 控制系統。制定危機爆發後所採取的相應措施，盡量將破壞程度減到最少。

Daily Backup Batch Script

C:\WINDOWS\system32\ntbackup.exe backup "@C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Windows NT\NTBackup\data\EPDEV01_02_daily.bks" /a /d "Set created %date% at %time%" /v:no /r:no /rs:no /hc:off /m daily /j "EPDEV01_02_daily" /l:s /f "G:\NTBackup\Daily\EPDEV01_02_daily.%date:~-4%%date:~4,2%%date:~7,2%.bkf"

Weekly Backup Batch

C:\WINDOWS\system32\ntbackup.exe backup "@C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Windows NT\NTBackup\data\EPDEV01_02_daily.bks" /a /d "Set created %date% at %time%" /v:no /r:no /rs:no /hc:off /m daily /j "EPDEV01_02_daily" /l:s /f "G:\NTBackup\Daily\EPDEV01_02_daily.%date:~-4%%date:~4,2%%date:~7,2%.bkf"

建立Language Converter的Batch File

Build a xxx.bat file with the following scripts inside the file:
native2ascii -encoding UTF-8 language_zh_HK.txt language_zh_HK.properties

兩句好用既SQL insert into ... select ... , create ... as select ...

[insert into ... select ... ]
=================
INSERT INTO Store_Information (store_name, Sales, Date)
SELECT store_name, Sales, Date
FROM Sales_Information
WHERE Year(Date) = 1998

[create ... as select ]
==============
create table t1 as
select
store_name,
avg(quantity) qty
from
store join sales using (store_key)
group by store_name;