Comments
Sort by recent activity
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 ...
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? ...
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...