Hi all,

I am migrating an sql database to mysql using mysql
migration toolkit. I see the script generated with .sql
generated. When i try take the same to mysql i see all the tables
migrated. But the database also contains views & procedures. I
selected these objects while migrating. I used show view status
viewname, show procedure status procname in mysql prompt. But i dont
see any views or preocedures. Please tell what is going wrong. How to
make sure even the views & procedures are also migrated. Please reply
soon


Thanks in advance.

On 6 Feb, 10:17, agnes...@gmail.com wrote:
> Hi all,
>
> I am migrating an sql database to mysql using mysql
> migration toolkit. I see the script generated with .sql
> generated. When i try take the same to mysql i see all the tables
> migrated. But the database also contains views & procedures. I
> selected these objects while migrating. I used show view status
> viewname, show procedure status procname in mysql prompt. But i dont
> see any views or preocedures. Please tell what is going wrong. How to
> make sure even the views & procedures are also migrated. Please reply
> soon
>
> Thanks in advance.

MySQL is an SQL database???

> MySQL is an SQL database???
I mean microsoft sql server 2005 database.
I am migrating microsoft sql server 2005 database to MySQL. Hope this
answers ur question.

On Wed, 6 Feb 2008 02:17:07 -0800 (PST), agnesroz@gmail.com wrote:
> Hi all,
>
> I am migrating an sql database to mysql using mysql
> migration toolkit. I see the script generated with .sql
> generated. When i try take the same to mysql i see all the tables
> migrated. But the database also contains views & procedures. I
> selected these objects while migrating. I used show view status
> viewname, show procedure status procname in mysql prompt. But i dont
> see any views or preocedures. Please tell what is going wrong. How to
> make sure even the views & procedures are also migrated. Please reply
> soon

Does the .sql file contain the SQL code to create the views and
procedures? If not, add the code to it.

--
"It's 106 light-years to Chicago, we've got a full chamber of anti-matter,
a half a pack of cigarettes, it's dark, and we're wearing visors."
"Engage."