Comments
Sort by recent activity
Thanks you red-gate
Today I update new version (3.1.9.12) and works fine.
Glad that snepshot helps
Radovan / comments
Thanks you red-gate
Today I update new version (3.1.9.12) and works fine.
Glad that snepshot helps
Radovan
Hi,
I have two snapshot for the databases that I can't compare.
I get error after registrate the databases, during the comparation.
My version if SQLCompare is 3.1.9.4
(with trial version everithing works fine).
Please send me an e_mail so I can send you snapshot of that databases.
Radovan / comments
Hi,
I have two snapshot for the databases that I can't compare.
I get error after registrate the databases, during the comparation.
My version if SQLCompare is 3.1.9.4
(with trial version everithin...
Hi,
I can successfully start and for with SQL response for same time.
After about 6 hours I have that message for connection error.
After I restart my computer (didn't change anything into configuration), everything works fine (and still working after 18 hours).
radovan / comments
Hi,
I can successfully start and for with SQL response for same time.
After about 6 hours I have that message for connection error.
After I restart my computer (didn't change anything into configur...
The probles is not permission.
I don't wont to sync them. I set ignore permision and it works fine.
The problem is that if I change assembly, and create new CLR function, sql compare generate CREATE ASSEMBLY, not ALTER ASSEMBLY.
That implicate in droping all CLR function existing in that assembly.
I just wont ALTER ASSEMBLY and create new function (new CLR function witnin assembly) / comments
The probles is not permission.
I don't wont to sync them. I set ignore permision and it works fine.
The problem is that if I change assembly, and create new CLR function, sql compare generate CREAT...
Thank you very much
radovan / comments
Thank you very much
radovan
Hi,
it helps me with saving sql script option, but not with
'Compare database following synchronization'.
How can I save this option?
Radovan / comments
Hi,
it helps me with saving sql script option, but not with
'Compare database following synchronization'.
How can I save this option?
Radovan
Hi,
Did you mean
select name from dbo.C.items. (database.schema.object)?
I have a lot view depending on other database (even on linked server) and everything works fine (if view are fine).
Often, I have two problem (not with SQL compare, but with creating view).
One is that underlining object is changed, and the other is that other database is not online (or onother server).
The best way to check that is to copy script in query window and try to run.
radovan / comments
Hi,
Did you mean
select name from dbo.C.items. (database.schema.object)?
I have a lot view depending on other database (even on linked server) and everything works fine (if view are fine).
Often, ...
Hi Andras,
It is true.
In options I include:
Ignore permissions
Ignore user parmision and role membership
Ignore users properties in cimparision.
I Include manualy only one store procedure to sync.
After that (when it can't sync) I create that test procedure and try it again.
It failes.
I try it on SQL 2000.
Radovan / comments
Hi Andras,
It is true.
In options I include:
Ignore permissions
Ignore user parmision and role membership
Ignore users properties in cimparision.
I Include manualy only one store procedure to sync....
I also have problem with users if script failed later (say in creating views ).
The problem is:
SQL Compare rolled back all script, BUT User (or role) are not rollback.
They stey created in database.
When I exclude some object, I can't sinchronize database, becuse, script thinks that they doesn't exists.
If I have users or roles in script, I have Refresh comparation before sinhronize them again / comments
I also have problem with users if script failed later (say in creating views ).
The problem is:
SQL Compare rolled back all script, BUT User (or role) are not rollback.
They stey created in databas...
I just found what was the problem.
I options I have option 'ignore permision' uncheck.
For that functions and stored procedures I have different permisions.
I have permisions into role on that objects.
When I try to sinchronize them nothing happens.
I have the following script (the scripts are the same for including role filter or excluding. )
I don't know how I can see difference in role security.
/*
Script created by SQL Compare from Red Gate Software Ltd at 30.11.2005 9:51:52
Run this script on bogibatina.birin to make it the same as server3.birin
Please back up your database before running this script
*/
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
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 / comments
I just found what was the problem.
I options I have option 'ignore permision' uncheck.
For that functions and stored procedures I have different permisions.
I have permisions into role on that obje...