Comments
Sort by recent activity
Normally script is used to update column name, add some values etc.
e.g. of the script applied after SQL compare is as
*/
IF ((SELECT COUNT(1) FROM DocumentNumberComponent) = 0 )
BEGIN
INSERT INTO [dbo].[DocumentNumberComponent]([Component],[Code],[Active]) VALUES( 'D Rer','DR',1)
INSERT INTO [dbo].[DocumentNumberComponent]([Component],[Code],[Active]) VALUES( 'Doc Category','DC',1)
INSERT INTO [dbo].[DocumentNumberComponent]([Component],[Code],[Active]) VALUES( 'Proj Ref','PR',1)
INSERT INTO [dbo].[DocumentNumberComponent]([Component],[Code],[Active]) VALUES( 'Publis Co','PC',1)
INSERT INTO [dbo].[DocumentNumberComponent]([Component],[Code],[Active]) VALUES( 'S W P','WP',1)
END
Many such scripts are applied after and before SQL Compare. / comments
Normally script is used to update column name, add some values etc.
e.g. of the script applied after SQL compare is as
*/
IF ((SELECT COUNT(1) FROM DocumentNumberComponent) = 0 )
BEGIN
INSERT I...
Is this not possible with SQL Compare ??? / comments
Is this not possible with SQL Compare ???
Hi Michelle,
(1) I tried by setting up of all possible combination of options in command line but no success.
Note: In project -> Options i have only default options.
(2) In UI i removed all checks in Project -> Options and tried to synch. and it worked. But the same thing is not workin in cmd even by setting /Options:n.
(3) How it is working through command line when i pass project parameter thats also a question? Here it is going to use default options but it does not work in cmd when /options:default is used.
(4) Note: For testing i have retored 2 test db i.e. test1 and test2 from the same back up. Then i have just removed one sp from test2. But things are not working for this. Very strange.
(5) Note: For cmd line, SQL compare is showing correct results but problem happens only while synchronisation.
I think above information is enough to explain the problem i am facing.
Appriciate concrete and prompt reply.
Regards
Nehal / comments
Hi Michelle,
(1) I tried by setting up of all possible combination of options in command line but no success.
Note: In project -> Options i have only default options.
(2) In UI i removed all checks...