Comments
Sort by recent activity
At what level are you setting the the Sections and properties included to be included.
Try setting them at the Server level. http://documentation.red-gate.com/pages ... =20185497# / comments
At what level are you setting the the Sections and properties included to be included.
Try setting them at the Server level.http://documentation.red-gate.com/pages ... =20185497#
When SQL Compare compares a schema, a semantic comparison will be performed (top grid) which will group the objects based on the rules you have applied to the deployment and other basic functionally similar syntax that will automatically be ignored. It is these differences that will be deployed.
The other comparison is a straight textual comparison, that will be displayed in the bottom SQL Differences pane. All textual differences will be highlighted here. We can try match the rows as best we can, but each method will have its limitations and we don't think it would be right to reorder the SQL at this stage. http://documentation.red-gate.com/displ ... different#
This is designed behavior and there are no plans to change the default behaviour. / comments
When SQL Compare compares a schema, a semantic comparison will be performed (top grid) which will group the objects based on the rules you have applied to the deployment and other basic functionall...
I believe you are missing the synchronize switch.
/Synchronize
Alias: /sync
Deploys the data after comparison. http://documentation.red-gate.com/displ ... mmand+line
You command will become
"C:\Program Files (x86)\Red Gate\SQL Data Compare 10\sqldatacompare.exe" /Project:"c:\DTS Executables\RedgateScripts\MyProject.sdc" /include:identical /sync / comments
I believe you are missing the synchronize switch.
/Synchronize
Alias: /sync
Deploys the data after comparison.http://documentation.red-gate.com/displ ... mmand+line
You command will become
"C:\Prog...
The syntax is fine.
I pretty much copied your command and it worked, I only changed the database name and the disk path.
The main thing it is compalining about is:
Password file does not exist: C:\redgate\dcr.txt
Try giving the log on account of the SQL Backup Agent explicit rights to the folder. / comments
The syntax is fine.
I pretty much copied your command and it worked, I only changed the database name and the disk path.
The main thing it is compalining about is:
Password file does not exist: C:\...
The error indicates that: Password file does not exist: C:\redgate\dcr.txt
Is the file name and path correct?
It could also be permissions to the folder.
The logon account of the SQL Backup Agent have rights to the folder? / comments
The error indicates that: Password file does not exist: C:\redgate\dcr.txt
Is the file name and path correct?
It could also be permissions to the folder.
The logon account of the SQL Backup Agent h...
I just did a quick test and yes you can encrypt with a password file and decrypt with just the password using the converter. / comments
I just did a quick test and yes you can encrypt with a password file and decrypt with just the password using the converter.
It doesn't appear that the password in a text file was implemented in the standalone converters.
I tried both sqb2mtf.exe and SqbConverter.exe and was unsuccessful.
If you want to convert a file from the command line you could use the convert command from the command line.
SQLBackupC.exe -I {instance name} -SQL "CONVERT 'C:\Backups\pubs.sqb' TO 'C:\Backups\pubs.bak' WITH PASSWORD = 'FILE:C:\mypasswords\password.txt'" http://documentation.red-gate.com/displ ... RTPASSWORD / comments
It doesn't appear that the password in a text file was implemented in the standalone converters.
I tried both sqb2mtf.exe and SqbConverter.exe and was unsuccessful.
If you want to convert a file fr...
You can only use a password when the backup (sqb) is encrypted.
The password is used to decrypt an encrypted sqb file during the conversion. / comments
You can only use a password when the backup (sqb) is encrypted.
The password is used to decrypt an encrypted sqb file during the conversion.
Do you have the SSMS Integration pack installed? http://documentation.red-gate.com/displ ... he+add-in# / comments
Do you have the SSMS Integration pack installed?http://documentation.red-gate.com/displ ... he+add-in#
We actually offer two tools to script out the entire database.
You will use SQL Compare to script out the structure of the database. http://www.red-gate.com/products/sql-de ... l-compare/
Then use SQL Data Compare to script out the contents of the database. http://www.red-gate.com/products/sql-de ... l-compare/ / comments
We actually offer two tools to script out the entire database.
You will use SQL Compare to script out the structure of the database.http://www.red-gate.com/products/sql-de ... l-compare/
Then use S...