Activity overview
Latest activity by jhilden
I'm having a problem with it not picking up migration scripts for some databases as well. I'm using SVN and SQL Server 2008. Is anyone else seeing this?
Note: in your "from" database if you right click and go to properties and then look in the extended properties tab you'll see that the version number, URL, and Migration scripts URL are all listed there. / comments
I'm having a problem with it not picking up migration scripts for some databases as well. I'm using SVN and SQL Server 2008. Is anyone else seeing this?
Note: in your "from" database if you right...
Thanks Manfred, I had 10.0 installed. With 10.1 I get that option. / comments
Thanks Manfred, I had 10.0 installed. With 10.1 I get that option.
is /scriptsfolderxml still available in the newest version of SQL Compare? I just tried and it says that the arg is not valid. / comments
is /scriptsfolderxml still available in the newest version of SQL Compare? I just tried and it says that the arg is not valid.
Sorry guys, I just didn't read enough in the documentation. Here is the solution: sqlcompare /server1:dev02 /db1:JaySQLCompare /version1:head /server2:dev02 /db2:JaySQLCompareTarget /verbose /sync /ScriptFile: "C:\foo.sql"
/ comments
Sorry guys, I just didn't read enough in the documentation. Here is the solution:sqlcompare /server1:dev02 /db1:JaySQLCompare /version1:head /server2:dev02 /db2:JaySQLCompareTarget /verbose /sync ...
sql compare command line - set source directly to SVN?
I'm evaluating SQL Source Control and SQL compare, I'm using the following command to compare:sqlcompare /server1:dev02 /db1:JaySQLCompare /version1:head /server2:dev02 /db2:JaySQLCompareTarget /ve...
David, I just saw your reply on the voting page:
The workaround for this is to prefix or suffix the code to a schema change. It's not ideal, but should work. Please vote for this issue if it affects you and hopefully we'll be able to implement a better fix.
I can accept that for now but putting in data changes into this product would make it much, much easier to use!
Thanks. / comments
David, I just saw your reply on the voting page:
The workaround for this is to prefix or suffix the code to a schema change. It's not ideal, but should work. Please vote for this issue if it affec...
David, thank you for your reply. Please advise me on the following scenario:
I have just committed a change that has static data only. How can I create a custom migration script for that change? When I try I get the error:
SQL Source control cannot create a migration script because the revisions you selected contain no schema changes, only data or metadata changes.
What is my work around now for generating a change script? I'd be happy to create the .sql file myself but when I look in SVN there is an associated .migrationScript file that I wouldn't also need to mimic. That would be quite error prone.
Any advice you have would be appreciated. / comments
David, thank you for your reply. Please advise me on the following scenario:
I have just committed a change that has static data only. How can I create a custom migration script for that change? ...
sql compare command line - how to send final script to file
I'm using SQL Source Control and testing out SQL Compare for continuous integration. What I'm testing now is that SQL compare successfully uses a couple custom migration scripts and a couple outma...
SSC not picking up static data update
I'm using SSC 3.0.9.18 on SSMS 2012 and I found the following:
I am tracking static data on a table with 3 columns, 6 rows. I updated the last column in each row and found that SSC did not pick up...