Options
Export Data Source to Script folder
BNaegele
Posts: 2
We are currently evaluating SQL Compare for our database update process.
I have two question about the Export Data Source to Script Folder function:
- Is it possible to export objects like stored procedures without their permissions. I don't find a option to remove the permissions.
- Is it possible to export objects including a drop statement at the head of each file.
Sample:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_xyz]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_xyz]
GO
By the way, the appliction looks very helpfull for us. But I'm missing the previoius two options.
Thanks
I have two question about the Export Data Source to Script Folder function:
- Is it possible to export objects like stored procedures without their permissions. I don't find a option to remove the permissions.
- Is it possible to export objects including a drop statement at the head of each file.
Sample:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_xyz]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_xyz]
GO
By the way, the appliction looks very helpfull for us. But I'm missing the previoius two options.
Thanks
Comments
2) It's not currently possible to do this. What kind of things do you envision doing with the objects with drop statements attached? You can probably do most of them by synchronizing the individual objects to the target database using SQL Compare.
Redgate Software