Migrating Views

Mar 18, 2010 at 2:42 AM

Hi,

When I use an existing database, the tool seems to ignore migrating views. Am I missing some configuration?

Thanks,

-Girish

Apr 19, 2010 at 2:39 PM

Hello. I also find  problems why tool ignore migrating views : 

1

SELECT dbo.V_LDS3_Expositor.Id_Ekspositor, dbo.V_LDS3_Expositor.ID_Construction, dbo.V_LDS3_ConstructionTypSpec.Construction,                dbo.V_LDS3_ConstructionTypSpec.PanelCount FROM  dbo.V_LDS3_Expositor INNER JOIN               dbo.V_LDS3_ConstructionTypSpec ON dbo.V_LDS3_Expositor.ID_Construction = dbo.V_LDS3_ConstructionTypSpec.ID_Construction

-- here I use another view inside first

2

SELECT TOP (100) PERCENT dbo.crs_Route.ID_Route, dbo.crs_Route.Dt, dbo.crs_Route.Flag_Approved, dbo.crs_Route.Id_TrRepres,                dbo.crs_TrRepres.Description AS TrRepresName, dbo.crs_Route.Description AS RouteDescription,                ISNULL(dbo.V_LDS2_RouteMeetingsCount.MeetingCount, 0) AS MeetingCount, dbo.GetFriendlyDate(dbo.crs_Route.Dt, 1, 1, 1, 0, 'ru') AS FriendlyDate,                'Неделя ' + CAST(DATEPART(ww, dbo.crs_Route.Dt) AS varchar) AS WeekFROM  dbo.crs_TrRepres INNER JOIN               dbo.crs_Route ON dbo.crs_TrRepres.Id_TrRepres = dbo.crs_Route.Id_TrRepres LEFT OUTER JOIN               dbo.V_LDS2_RouteMeetingsCount ON dbo.crs_Route.ID_Route = dbo.V_LDS2_RouteMeetingsCount.ID_RouteORDER BY dbo.crs_Route.Dt

-- here i Use ScalarFunction inside sp