How can we help you today? How can we help you today?
jschwarz
Activity overview Badges (0) Posts (3) Comments (8)

Comments

Sort by recent activity
I opened this same question as a support ticket, and although RedGate does not have a supported method of making this happen, they did direct me to this link https://alessandroalpi.blog/2016/06/28/automatically-link-databases-to-red-gate-sql-source-control/ I've seen several threads in the forum asking for the same or similar, but I haven't seen anyone pass along this link yet. I am adding it here for the benefit of everyone seeking to do the same. I will be trying out this method today and will report back the results. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Can sqlcompare commit a brand new database to svn via cli?
I opened this same question as a support ticket, and although RedGate does not have a supported method of making this happen, they did direct me to this link https://alessandroalpi.blog/2016/06/28/...
0 votes
Sergio R, I have SQL Compare Pro, and I am trying to accomplish the same thing as the op. Can you direct me to instructions on how to get an initial link and commit accomplished from the cli? Like many on the forum, I have had a problem getting this to work from the cli even with the PRO version of the software. Here is an example of my attempt to use the cli for this purpose, and the resulting error, I've seen many others reference this same error on the forum but never seen a definitive answer. When the cli tries to connect to SVN it gets denied due to authentication. In my case I have verified that the url in question is definitely avai Can you please take a look and direct me to a resource that can help me accomplish this? U:\>E:\RedGate\SQLCompare11\sqlcompare.exe /Server1:TSTDBATEST /Database1:DbaTesting2 /sourcecontrol2 /Revision2:HEAD /ScriptsFolderXML:F:\MSSQL\SQLDeployment\SQLSourceXML\Dbatesting2SourceXMLLink.txt /ignoreparsererrors /v /sync /force SQL Compare: activated, edition: professional, serial number: 512-010-190515-9169 SQL Compare Command Line V11.4.10.109 ====================================================================================================================================================================================================== Copyright Copyright c 1999 - 2016 Red Gate Software Ltd Argument /server1 has value 'TSTDBATEST' Argument /database1 has value 'DbaTesting2' Argument /sourcecontrol2 has value 'True' Argument /revision2 has value 'HEAD' Argument /scriptsfolderxml has value 'F:\MSSQL\SQLDeployment\SQLSourceXML\Dbatesting2SourceXMLLink.txt' Argument /ignoreParserErrors has value 'True' Argument /verbose has value 'True' Argument /synchronize has value 'True' Argument /force has value 'True' Comparing database TSTDBATEST.DbaTesting2 with database .... Registering data sources Error: Comparison of 'TSTDBATEST.DbaTesting2' and '.' failed: URL 'https://svn.artisanpartners.com/svn/Databases/Dbatesting2' doesn't exist / comments
  1. Community
  2. SQL Source Control
  3. CLI Operation
Sergio R, I have SQL Compare Pro, and I am trying to accomplish the same thing as the op. Can you direct me to instructions on how to get an initial link and commit accomplished from the cli? Like...
0 votes
ChrisMeek, you may find this link to have the information that you need... https://alessandroalpi.blog/2016/06/28/automatically-link-databases-to-red-gate-sql-source-control/ / comments
  1. Community
  2. SQL Source Control
  3. CLI Operation
ChrisMeek, you may find this link to have the information that you need...https://alessandroalpi.blog/2016/06/28/automatically-link-databases-to-red-gate-sql-source-control/
0 votes
Wow Pete, that thread is two years old! uh, thanks i guess... Have started another thread recently, two years later, still the same problem, at least i'm not spam anymore?!? hard to find a "forum" useful that put me in the spam bucket for two years / comments
  1. Community
  2. SQL Compare 11
  3. AddDatabaseUseStatement not giving desired result
Wow Pete, that thread is two years old! uh, thanks i guess... Have started another thread recently, two years later, still the same problem, at least i'm not spam anymore?!? hard to find a "forum...
0 votes
I've also tried adding the "Database1" parameter to the command to specify the database name, but it seems to be an incompatible combination of swithces... - Error: The /sourcecontrol1 switch cannot be used in conjunction with the /database1 switch. Please use SQLCompare.exe /? or SQLCompare.exe /verbose /? for more information. / comments
  1. Community
  2. SQL Compare 11
  3. AddDatabaseUseStatement not giving desired result
I've also tried adding the "Database1" parameter to the command to specify the database name, but it seems to be an incompatible combination of swithces... - Error: The /sourcecontrol1 switch canno...
0 votes
This is still not working properly, i tried to upload details as a reply to this thread, but my updates are being treated as SPAM! / comments
  1. Community
  2. SQL Compare 11
  3. AddDatabaseUseStatement not giving desired result
This is still not working properly, i tried to upload details as a reply to this thread, but my updates are being treated as SPAM!
0 votes
Chris, you were close... the dialogue box that it's trying to display is the box that asks if I would like to "help improve RedGate Software". I did check the registry, and add permissions as you suggested. I still encountered the same problem. In order to get this error to disappear, I had to log into the server as the service account that ends up executing the stored proc, and manually run SQL Data Compare from the command line, and click through the "help improve RedGate" pop-up. Now it will work when executed through the stored proc. Although I did click "No" on the "help improve RedGate" prompt, I do have a suggestion... / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. Modal dialog box exception.
Chris, you were close... the dialogue box that it's trying to display is the box that asks if I would like to "help improve RedGate Software". I did check the registry, and add permissions as you ...
0 votes
I had this error also, and found that it was due to the data not being the same in the tables. In my case, the source database had records in the table where the "conflict" occured. I synched the data between the tables, and then added the FK and that did the trick. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. [547] The ALTER TABLE statement conflicted with the FOREIGN
I had this error also, and found that it was due to the data not being the same in the tables. In my case, the source database had records in the table where the "conflict" occured. I synched the ...
0 votes
Total activity
16
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
5