Activity overview
Latest activity by Liju
Hi Brian,
My exact requirement is below.
I have a folder with 10 SPs. I neeed to give this folder as 1 input to SQLCompare and my Existing DB as second input. I wish to get output as a single script which have the gist of 10 SPs available in the 1st folder. Later i can use the same script to update the DB with the changes available at the folder1.
The issue i am facing is below.
--> Sample SP available at the folder below:
USE [databaseName]
GO -- Delete the Sproc if it already exists
Declare @DB nvarchar(128)
Set @DB = db_name()
exec logging.dbo.SP1 'SP2',@DB
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[SP2]
(
//Variable Declerations
)
AS
DECLARE
BEGIN TRY
//Logic
END TRY
BEGIN CATCH
//LoggingLogic
END CATCH
Go // Call SP3 which give permission
Declare @DB nvarchar(128)
Set @DB = db_name()
exec SP3 'SP1', @DB
GO
--> I am able to create an output script by using SQLCompare , but it have few sections missing , which is needed actually .
The missing sections are -- Delete the Sproc if it already exists
Declare @DB nvarchar(128)
Set @DB = db_name()
exec logging.dbo.SP1 'SP2',@DB
GO // Call SP3 which give permission
Declare @DB nvarchar(128)
Set @DB = db_name()
exec SP3 'SP1', @DB
GO
I wish to get theese sections too included in my query result generated by SqlCompare.
Thanks and Regards
Liju G / comments
Hi Brian,
My exact requirement is below.
I have a folder with 10 SPs. I neeed to give this folder as 1 input to SQLCompare and my Existing DB as second input. I wish to get output as a single scr...
SQL Compare ignores Stored procedure calls using "exec" .
Hi ,
I have a folder containing few stored procedures which i have created for my project. My requirement is , i need to create a single DB script which have the contents of all stored procedure a...