Activity overview
Latest activity by SeanRhone
Okay, while it seeing the difference in the "History" popup it still does not show the proc being in TFS - It shows as only in the shared database. / comments
Okay, while it seeing the difference in the "History" popup it still does not show the proc being in TFS - It shows as only in the shared database.
Okay, so to try and fix the issue of the stored procedure being in TFS and run in the shared production database (outside of Redgate tools) I deleted the proc in TFS and committed the change from sql source control, I then checked the file out in TFS and altered the contents with the updated logic and then I used SQL Compare to compare TFS to the shared database hoping I could generate a script and it still does not see the script being in TFS. If I edit the project and select "Version: <Select a version from history...> it does find the change but if I leave "Version: Latest (Head)" it does not see it.
very frustraiting! / comments
Okay, so to try and fix the issue of the stored procedure being in TFS and run in the shared production database (outside of Redgate tools) I deleted the proc in TFS and committed the change from s...
The process is
1) Developer creates a new stored procedure using SSMS (no Redgate tools)
2) They test / QA etc then check the file into TFS (our development branch)
3) They execute the script in the Shared database using SSMS (again no Redgate tools)
4) I then migrate changes from the development TFS branch up to QA then production. The production branch is what is linked to the Redgate SQL source control.
5) I then use the Redgate tools to make sure everything is in sync. / comments
The process is
1) Developer creates a new stored procedure using SSMS (no Redgate tools)
2) They test / QA etc then check the file into TFS (our development branch)
3) They execute the script in th...
When I commit the file (showing as new) in does commit the file then blows up with an error about same stored procedure in multiple files (my language but close in meaning).
When I look at TFS afterwards I now have two files the original stored procedure I merged up from the development branch and a new one name "procname1"; so what happened is it committed the file and just append a "1" to the file name. / comments
When I commit the file (showing as new) in does commit the file then blows up with an error about same stored procedure in multiple files (my language but close in meaning).
When I look at TFS afte...
We are using the Shared model / comments
We are using the Shared model
SQL Source Control not seeing file already exists
I have set up a project in TFS using the plugin in SSMS and everything was working fine, the problem seems to happen when someone added a new stored procedure to the database without using sql sour...
Thanks David - After applying that update the command line works now! / comments
Thanks David - After applying that update the command line works now!
Found out that the xml was incorrect and chaged to
<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<ISOCCompareLocation version="1" type="TfsLocation">
<ServerUrl>http://Server:8080/tfs/legacy</ServerUrl>
<SourceControlFolder>$/Databases/E/Development/QM</SourceControlFolder>
</ISOCCompareLocation>
Still getting the same error message though / comments
Found out that the xml was incorrect and chaged to
<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<ISOCCompareLocation version="1" type="TfsLocation">
<ServerUrl>http://Server:8080/tfs/le...
I have a file names Testing2.xml which contains the following
<?xml version="1.0"?>
<commandline>
<ISOCCompareLocation version="1" type="TfsLocation">
<RepositoryUrl> http://server:8080/tfs/legacy/$/Databas ... lopment/QM
</RepositoryUrl>
<ISOCCompareLocation>
</commandline>
calling the
sqlcompare.exe /sourcecontrol1 /revision1:head /scriptsfolderxml:LocationToTesting.xml /database2:QM server2:MySqlDatabaseName
I'm getting an error message that states
Error: Invalid connection database connection parameter: Values cannot be null. Parameter name: scriptFolderLocation
Since I cannot find an example on the syntax, I'm not sure what to change / comments
I have a file names Testing2.xml which contains the following
<?xml version="1.0"?>
<commandline>
<ISOCCompareLocation version="1" type="TfsLocation">
<RepositoryUrl>http://server:8080/tfs/legacy/$...
Is there an example of command line use of argument file com parings Tfs and SQL database? I would like to set up CI between the Tfs and my development database but cannot seem to get the syntax correct for using a Tfs repository as the source1 and a sql database as source2.
Any help is greatly appreciated! / comments
Is there an example of command line use of argument file com parings Tfs and SQL database? I would like to set up CI between the Tfs and my development database but cannot seem to get the syntax co...