Re: MS SQL Server 2000 migration

[Chagh]

I tried the trials 3 monthes ago, non of them migrated a complete DB. none of them migrated SPs. some of them couldn't migrate forein keys, PKs, views, ....
any way the best way of migratinf SPs is:

1. generate SQL script of all of them in one sql file(in SQLServer)
2. do some general changes(e.g. replace @ with var, or go with end$$)
3. use a tool which can load SQL statement in its editor and edit and execute them(i use Query Browser) and load the script into tool editor.
4. add "Delimiter $$" at the first line of script and "Delimiter ;" at the end of it.
5. change the syntax of creating SPs to match with MySQL(the worst part!)
6. execute the script(you may find many errors(specially for syntax) which you should deal)

Chagh