Compare and merge schemas

DbSchema Scripts, Schema & Synchronization
gratien.falcoz
Posts: 23
Joined: Tue Aug 21, 2012 9:44 am

Re: Compare and merge schemas

Post by gratien.falcoz » Fri Oct 05, 2012 12:52 pm

Ok i think i found the final problem :

if you create a procedure with a schema and then change the schema by alter, the routine definition stays what it was at the origin :

in the situation above the routine definition says :

Code: Select all

SELECT routine_definition FROM information_schema.routines 
WHERE routine_type='PROCEDURE' AND routine_schema='TracePrep'
gives you :

Code: Select all

CREATE PROCEDURE [Trace].[Pilote_InsertPassageContenant_160]


That is stange !!! the correct schema of the routine is contained in the routine_schema column, not in the text !!
if you try to modify the stored procedure with management studio, you have the correct statement which means it chages the statement 'on the fly'

I don't know if you can handle this issue, but in any case, thank you for your great support !!

donose.mihai
Posts: 470
Joined: Thu Apr 07, 2011 11:05 am

Re: Compare and merge schemas

Post by donose.mihai » Thu Oct 11, 2012 8:33 am

Hello,

The issue has been updated, hope we can fix this in one of our next updates.

madalinstuntcars2
Posts: 1
Joined: Fri May 11, 2018 7:41 am

Re: Compare and merge schemas

Post by madalinstuntcars2 » Fri May 11, 2018 7:43 am

I'll open a ticket for this issue and it will be solved. :D :D

Post Reply