MsSQL Taşıdım "Could not find stored procedure" hatası alıyorum?

Merhaba,

MsSQL dosyamı eski server'dan yeni server'ıma taşıdık ancak sitem hata veriyor çözemedik hatayı

yardımlarınız için teşekür ederim. yazılımın adı proticaret

Server Error in '/' Application.[HR][/HR]

Could not find stored procedure 'GetPortalSettings5b'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'GetPortalSettings5b'.

Source Error:

[TABLE="width: 100%"]
[TR]
[TD]An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.[/TD]
[/TR]
[/TABLE]

Procedure'ler gelmemiş olabilir. Taşıma işlemini nasıl yaptınız?
Yeni taşıdığınız yerde GetPortalSettings5b isimli stored procedure bulunamıyor.

mssql'dan hiç anlamıyorumki hocam eski firma kendisi taşıdı procedure nasıl alacağım şimdi ordan onları nası taşırımki

En iyi yol komple mdf dosyalarını ve .bak dosyası olarak yedeklerini tekrar istemek. Firmana söyle taşıma işlemindeki sıkıntını ve halletsinler. Madem taşıma işini yapıyorlar adam gibi taşısınlar.

CreateDatabase.sql isimli bir dosya vardır install klasöründe. Onun içinde ilgili prosedürü aratıp ilgili kodları kopyalayın ve mssql sorgu ekranına yapıştırıp çalıştırın (F5 - Execute)

/****** Object:  StoredProcedure [dbo].[GetPortalSettings5b]    Script Date: 01/19/2013 20:40:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE  PROCEDURE [dbo].[GetPortalSettings5b]
(
    @PortalId      int,
    @TabId         int,    
	@IsEmarket bit OUTPUT,
    @PortalName    nvarchar(128) OUTPUT,
	@Email  nvarchar(100) OUTPUT,
    @AlwaysShowEditButton bit OUTPUT,
    @TabName       nvarchar (50)  OUTPUT,
    @TabOrder      int OUTPUT,
    @ParentId      int OUTPUT,	--JH return parentId for menu
    @IconURL      nvarchar(50) OUTPUT,	--JH return IconURL for menu
    @MobileTabName nvarchar (50)  OUTPUT,
    @AuthRoles     nvarchar (256) OUTPUT,
    @ShowMobile    bit OUTPUT,
    @ShowMenu    bit OUTPUT,
    @ShowFotterMenu    bit OUTPUT,
    @HeadMenu    bit OUTPUT,
	@Title nvarchar (256) OUTPUT,
	@Description nvarchar (256) OUTPUT,
	@Keywords nvarchar (256) OUTPUT,
	@HasAction bit=0 OUTPUT,
	@Redirect bit OUTPUT,
	@RedirectUrl nvarchar (256) OUTPUT,
	@Url nvarchar (256) OUTPUT,
	@CargoLimit decimal(18,2) OUTPUT,
	@Template  nvarchar(50)='default' OUTPUT ,
@BannerPath		nvarchar(50)='' OUTPUT, 
@BannerWidth	 nvarchar(10)='0' OUTPUT ,
@BannerHeight	  nvarchar(10)='0' OUTPUT ,
@LogoPath		 nvarchar(50)='' OUTPUT ,
@LogoWidth		nvarchar(10)='0' OUTPUT,  
@LogoHeight		 nvarchar(10)='0' OUTPUT ,
@LocalIp		nvarchar(15)='' OUTPUT,
@UserName		 nvarchar(20)='sa' OUTPUT,
@Password		 nvarchar(20)='' OUTPUT,
@LocalDatabase nvarchar(20)='VEGADB' OUTPUT,
@ItegrationType nvarchar(20)='VEGA' OUTPUT,
@Firma nvarchar(20)='100' OUTPUT,
@Donem nvarchar(20)='1' OUTPUT,
@CouponIsActive bit=0 OUTPUT,
@CouponDiscount decimal(18,2)=0 OUTPUT,
@CouponLimit decimal(18,2)=0 OUTPUT,
@CouponStartDate smalldatetime output,
@CouponEndDate smalldatetime output,

@PointsIsActive		bit OUTPUT,
@PointsValue		decimal(18,2) OUTPUT,
@PointsMoneyValue  decimal(18,6) OUTPUT,
@PointsMoneyLimit  decimal(18,2) OUTPUT,
@PointsReviewValue decimal(18,2) OUTPUT,
@PointsAdviceValue decimal(18,2) OUTPUT,
@SmsUserName varchar(20) OUTPUT,
@SmsPwd  varchar(20) OUTPUT,
@SmsCompany varchar(10) OUTPUT,
@SmsAdmin varchar(11) OUTPUT,
@SmsSendToAdmin bit=0 OUTPUT,
@SmsSendToUser bit=0 OUTPUT,
@SmsSendForPassword bit=0 OUTPUT,
@SmsSendNewUser bit=0 OUTPUT,
@CloseDate smalldatetime OUTPUT
)
AS

/* First, get Out Params */
IF @TabId = 0 
    SELECT TOP 1
       
        @PortalName    = Portals.PortalName,
        @Template =Portals.Template,
@BannerPath	=Portals.BannerPath	,		
@BannerWidth=Portals.BannerWidth,		
@BannerHeight=Portals.BannerHeight,
@LogoPath=Portals.LogoPath		,
@LogoWidth=Portals.LogoWidth	,	
@LogoHeight	=Portals.LogoHeight	,	
@LocalIp=Portals.LocalIp		,
@UserName=Portals.UserName		,
@Password=Portals.Password		,
@LocalDatabase=Portals.LocalDatabase,        
@Email=Portals.Email,
@IsEmarket=Portals.IsEmarket,
    @ShowMenu=    Portals.ShowMenu,
    @ShowFotterMenu=Portals.ShowFotterMenu,
    @HeadMenu=    Portals.HeadMenu,
        @AlwaysShowEditButton = Portals.AlwaysShowEditButton,
        @TabId         = Tabs.TabId,
        @TabOrder      = Tabs.TabOrder,
        @ParentId      = isnull(Tabs.ParentId,-1), --JH
        @IconURL      = isnull(Tabs.IconURL,''), --JH
        @TabName       = Tabs.TabName,
        @MobileTabName = Tabs.MobileTabName,
        @AuthRoles     = Tabs.AuthorizedRoles,
        @ShowMobile    = Tabs.ShowMobile,
        @Title	= Tabs.Title,
        @Description = Tabs.Description,
        @Keywords = Tabs.Keywords,
@HasAction=HasAction,
@Redirect=Redirect,
@RedirectUrl=RedirectUrl,
@Url=Url,
@CargoLimit=Portals.CargoLimit,
@ItegrationType =Portals.ItegrationType,
@Firma = Portals.Firma,
@Donem =Portals.Donem,
@CouponIsActive=isnull(Portals.CouponIsActive,0),
@CouponDiscount=isnull(Portals.CouponDiscount,0),
@CouponLimit=isnull(Portals.CouponLimit,0),
@CouponStartDate= CouponStartDate,
@CouponEndDate =CouponEndDate,
@PointsIsActive	=isnull(PointsIsActive,0),
@PointsValue=isnull(PointsValue,0),		
@PointsMoneyValue =isnull(PointsMoneyValue,0),
@PointsMoneyLimit =isnull(PointsMoneyLimit,0),
@PointsReviewValue=isnull(PointsReviewValue,0),
@PointsAdviceValue=isnull(PointsAdviceValue,0),
@SmsUserName=Portals.SmsUserName,
@SmsPwd=Portals.SmsPwd,
@SmsCompany =Portals.SmsCompany,
@SmsAdmin =Portals.SmsAdmin,
@SmsSendToAdmin = Portals.SmsSendToAdmin ,
@SmsSendToUser = Portals.SmsSendToUser,
@SmsSendForPassword = Portals.SmsSendForPassword,
@SmsSendNewUser=Portals.SmsSendNewUser,
@CloseDate=Portals.CloseDate
--,@FotterHtml=Portals.FotterHtml,
--@BannerHtml=Portals.BannerHtml

    FROM
        Tabs
    INNER JOIN
        Portals ON Tabs.PortalId = Portals.PortalId
        
    WHERE
        Portals.PortalId=@PortalId
        
    ORDER BY
        TabOrder

ELSE 
    SELECT
       
        @PortalName    = Portals.PortalName,
           @Template =Portals.Template,
           @BannerPath	=Portals.BannerPath	,		
@BannerWidth=Portals.BannerWidth,		
@BannerHeight=Portals.BannerHeight,
@LogoPath=Portals.LogoPath		,
@LogoWidth=Portals.LogoWidth	,	
@LogoHeight	=Portals.LogoHeight	,	
@LocalIp=Portals.LocalIp		,
@UserName=Portals.UserName		,
@Password=Portals.Password		,
@LocalDatabase=Portals.LocalDatabase,      
@Email=Portals.Email,
        @IsEmarket=Portals.IsEmarket,
    @ShowMenu=    Portals.ShowMenu,
    @ShowFotterMenu=Portals.ShowFotterMenu,
    @HeadMenu=    Portals.HeadMenu,
    @AlwaysShowEditButton = Portals.AlwaysShowEditButton,
        @TabName       = Tabs.TabName,
        @TabOrder      = Tabs.TabOrder,
        @ParentId      = isnull(Tabs.ParentId,-1), --JH
        @IconURL      = isnull(Tabs.IconURL,''), --JH
        @MobileTabName = Tabs.MobileTabName,
        @AuthRoles     = Tabs.AuthorizedRoles,
        @ShowMobile    = Tabs.ShowMobile,
        @Title	= Tabs.Title,
        @Description = Tabs.Description,
        @Keywords = Tabs.Keywords,
@HasAction=HasAction,
@Redirect=Redirect,
@RedirectUrl=RedirectUrl,
@Url=Url,
@CargoLimit=Portals.CargoLimit,
@ItegrationType =Portals.ItegrationType,
@Firma = Portals.Firma,
@Donem =Portals.Donem,
@CouponIsActive=isnull(Portals.CouponIsActive,0),
@CouponDiscount=isnull(Portals.CouponDiscount,0),
@CouponLimit=isnull(Portals.CouponLimit,0),
@CouponStartDate= CouponStartDate,
@CouponEndDate =CouponEndDate,
@PointsIsActive	=isnull(PointsIsActive,0),
@PointsValue=isnull(PointsValue,0),		
@PointsMoneyValue =isnull(PointsMoneyValue,0),
@PointsMoneyLimit =isnull(PointsMoneyLimit,0),
@PointsReviewValue=isnull(PointsReviewValue,0),
@PointsAdviceValue=isnull(PointsAdviceValue,0),
@SmsUserName=Portals.SmsUserName,
@SmsPwd=Portals.SmsPwd,
@SmsCompany =Portals.SmsCompany,
@SmsAdmin =Portals.SmsAdmin,
@SmsSendToAdmin = Portals.SmsSendToAdmin ,
@SmsSendToUser = Portals.SmsSendToUser,
@SmsSendForPassword = Portals.SmsSendForPassword,
@SmsSendNewUser=Portals.SmsSendNewUser,
@CloseDate=Portals.CloseDate
--,@FotterHtml=Portals.FotterHtml,
--@BannerHtml=Portals.BannerHtml
    FROM
        Tabs
    INNER JOIN
        Portals ON Tabs.PortalId = Portals.PortalId
        
    WHERE
        TabId=@TabId

/* Get Tabs list */
SELECT  
    TabName,
    AuthorizedRoles,
    TabId,
    isnull(ParentId, -1) ParentId, --JH
    isnull(IconURL, '') IconURL, --JH
    TabOrder,
HasAction,
Redirect,
RedirectUrl,
Url,
ChildCount
    
FROM    
    Tabs
    
WHERE   
    PortalId = @PortalId
    
ORDER BY
    TabOrder

/* html */
/* First, get Out Params */

    SELECT TOP 1
        FotterHtml,BannerHtml

    FROM
        Portals 
        
    WHERE
        PortalId=@PortalId
         

/* Get Mobile Tabs list */
SELECT  
    MobileTabName,
    AuthorizedRoles,
    TabId,
    isnull(ParentId, -1) ParentId, --JH
    isnull(IconURL, '') IconURL, --JH
    ShowMobile,
    HasAction
FROM    
    Tabs
    
WHERE   
    PortalId = @PortalId
  AND
    ShowMobile = 1
    
ORDER BY
    TabOrder

/* Then, get the DataTable of module info */
SELECT  
    *
    
FROM
    Modules
  INNER JOIN
    ModuleDefinitions ON Modules.ModuleDefId = ModuleDefinitions.ModuleDefId
    
WHERE   
    TabId = @TabId
    
ORDER BY
    ModuleOrder
GO

bu mu? tam almışmıyım kodu

Tamam kodun o ama başka eksik procedure'ler varsa diye direk procedure'lerin script'ini alsaydın bence daha iyi olurdu.

Aslında oda doğru abi şimdi eski firmayı aradım tamam kardeşim tekrar taşıyoruz dedi. İşin kötü yanı hosting'i natro'dan aldım natro veritabanına taşırken backup dosyası kabul etmiyo query olacak diyo

--R10.NET; Flood Engellendi -->-> Yeni yazılan mesaj 16:38:45 -->-> Daha önceki mesaj 16:28:25 --

Nalet proticareti aktardık abi ama şimdide

Server Error in '/' Application.

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

Requested URL: /install/default.aspx


install'a git diyo anlayamadım

Burada Proticaretin niye lanetliği olsun canım

Hatada "insall/default.aspx" yok diyor. Verileri IMPORT / EXPORT data ile Query olarak alabilirsiniz MSSQL'de. Ö.M. atarak bilgileri gönderebilirseniz yardımcı olmaya çalışırım hocam.

İyi çalışmalar.