User profile for gsoules

Activity overview Badges (0) Posts (2) Comments (2)

Activity overview

Latest activity by gsoules

Apparently this is a known problem in version 4 (see http://www.red-gate.com/MessageBoard/vi ... procedures), but I am raising the issue again because of its importance. I just spent an hour trying...

0 followers 0 comments 0 votes

Okay -- it's not a bug or a feature. It was user error, I think. Having never seen the SQL Compare user interface before, I had been clicking around here and there to familiarize myself with the product. Somehow -- and this is the strange part -- I thought I had only one table checked for synchronization when in fact all User objects were checked. Because there were users in the remote DB (added by my web host) that did not exist in my local DB, SQL Compare dropped them. I have since used the Filter feature to exclude and hide User objects so that this cannot happen I again. As a happy ending, I used SQL Compare to synchronize all of my local asp_net tables and views with the remote versions (they differed in auto-generated contraint names) and it worked perfectly. / comments

Okay -- it's not a bug or a feature. It was user error, I think. Having never seen the SQL Compare user interface before, I had been clicking around here and there to familiarize myself with the p...

0 votes

I see what happened. 1. To test SQL Compare I had removed a column (Customers.TourGroupName) from my local DB. 2. SQL Compare emitted T-SQL to remove the remote column, but at the end of the script it dropped me (mapsalive) as a user on the remote DB. The script is below. 3. With the user gone, I could no longer access my DB. Is this a bug or a feature? George SET NUMERIC_ROUNDABORT OFF GO SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON GO IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors GO CREATE TABLE #tmpErrors (Error int) GO SET XACT_ABORT ON GO SET TRANSACTION ISOLATION LEVEL SERIALIZABLE GO BEGIN TRANSACTION GO PRINT N'Altering [dbo].[Customers]' GO ALTER TABLE [dbo].[Customers] DROP COLUMN [TourGroupName] GO @TRANCOUNT>0 ROLLBACK TRANSACTION GO @TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END GO PRINT N'Creating [dbo].[AppPages]' GO CREATE TABLE [dbo].[AppPages] ( [Id] [int] NOT NULL IDENTITY(1, 1), [PageName] [nchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) GO @TRANCOUNT>0 ROLLBACK TRANSACTION GO @TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END GO PRINT N'Creating primary key [PK_AppPages] on [dbo].[AppPages]' GO ALTER TABLE [dbo].[AppPages] ADD CONSTRAINT [PK_AppPages] PRIMARY KEY CLUSTERED ([Id]) GO @TRANCOUNT>0 ROLLBACK TRANSACTION GO @TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END GO IF EXISTS (SELECT * FROM #tmpErrors) ROLLBACK TRANSACTION GO @TRANCOUNT>0 BEGIN PRINT 'The database update succeeded' COMMIT TRANSACTION END ELSE PRINT 'The database update failed' GO DROP TABLE #tmpErrors GO PRINT N'Dropping users' GO DROP USER [OW\sqlservice] GO DROP USER [mapsalive] GO / comments

I see what happened. 1. To test SQL Compare I had removed a column (Customers.TourGroupName) from my local DB. 2. SQL Compare emitted T-SQL to remove the remote column, but at the end of the scri...

0 votes

DB modified though permission error caused sync to fail

Just downloaded SQL Compare and SQL Data Compare and tried some simple synchronizations -- they worked great; however... When I tried to sync one of my tables that had dependencies on the asp_net t...

1 follower 2 comments 0 votes

Total activity: 5
Last activity: February 05, 2025 15:53
Member since: February 05, 2025 08:27

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 1

How can we help you today?

gsoules

Activity overview