sp_MSForeachtable statement hangs

[flyway]

Original author: kavithap...@gmail.com (June 03, 2013 06:53:56)

Hi,

I am trying to copy data from one DB to another. Before copying I wan't to turn off all the constraints in the DB. Hence I call the following statement:

exec sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'

But I get a "query timed out" exception while executing the script with flyway. I have attached the complete script in this issue.

Please check and provide me a solution for this issue.

Original issue: http://code.google.com/p/flyway/issues/detail?id=508

[flyway]

From kavithap...@gmail.com on June 05, 2013 05:35:03
Could you please provide any solution for this issue.

[ruchirsachdeva]

Is this bug fixed, or is there any plan to fix this ?
It has been 2 years, and this has not even been assigned to anyone.

[axelfontaine]

Are you running in the same issue? I am not sure it can be fixed as Flyway holds a lock on its metadata table while migrating to make this safe for multiple concurrent nodes.

Any suggestions welcome.

[venkatamutyala]

I ran into a similar issue and my work around was to check to see if the the object name contained '%flyway%' if not, execute the changes to the object.

[axelfontaine]

This is now working.

[pranay1619]

I’m facing same issue. Can anyone help me please