Activity overview
Latest activity by Nehal.Shah
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...
SQL compare command line gives error while it works with UI
Hi,
I am evaluating ‘command line’ facility in SQL compare tool.
SQL compare version is ‘8.1.2.44’ and dbs are created on SQL server 2008.
This I mainly require to automate my routine steps...
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 ???
Can i use Dos command with SQL compare ?
Hi,
I am using SQL Compare to compare and Synchronize the database.
I want to automate repetative task of SQL compare and synchronize.
Can i do this with SQL Compare?
Regards
Nehal
How apply script and synchronize db in one go
Hi,
I have 2 versions of code say v1.1 and v1.2 and hence 2 db.
Whenevener i have to upgrade any site from v1.1 to v1.2 i have to do following steps:
(1) Apply script to db through query analyser (...
How to list a group of script and apply it depending on the
Hi,
We are having license copy of SQL Compare and multiscript.
We have one requirement which I don’t know how to achieve.
We need to upgrade database when we want to upgrade to higher version.
Fo...
How to automate SQL Compare steps
Hi,
One of my build steps involves usage of SQL compare tool.
i.e. After each build i need to do db compare and update live with the latest one.
All other parts of build i have automated using batc...