User profile for Chris Auckland

Thanks for your post. I'm afraid SQL Source Control doesn't support SSMS express. Only the full versions of SSMS are supported. For a complete list of requirements, please visit: <http://www.red-gate.com/products/sql-development/sql-source-control/requirements> / comments

Thanks for your post. I'm afraid SQL Source Control doesn't support SSMS express. Only the full versions of SSMS are supported. For a complete list of requirements, please visit: <http://www.red-ga...

0 votes

Thanks for your reply. We actually have a bug open to remove the message from the Toolbelt installer that mentions SSMS express. SQL Source control will work with SSMS 2008 express, but it is not supported. From what I can gather, it doesn't work at all with SSMS 2005 express. / comments

Thanks for your reply. We actually have a bug open to remove the message from the Toolbelt installer that mentions SSMS express. SQL Source control will work with SSMS 2008 express, but it is not s...

0 votes

I worked on this issue with Nancy through a private support ticket. We came to the conclusion that the issue was probably caused by a corruption in the backupfiles_copylist table. Nancy cleared the tale, and this seems to have cleared up the issue on this occasion. If you clear the copylist table, you will need to manually copy any pending transactions logs manually. You can clear the table using he following query: EXEC MASTER..sqbdata 'delete from backupfiles_copylist' / comments

I worked on this issue with Nancy through a private support ticket. We came to the conclusion that the issue was probably caused by a corruption in the backupfiles_copylist table. Nancy cleared the...

0 votes

Thanks for your post. As long as [10.1.1.1\PROD].[ProdDB] is an online SQL Server database, then you should be able to connect to it to compare. Are you able to connect using the same credentials with SSMS? Can you also check the following document, to make sure your user account has the necessary permissions. http://www.red-gate.com/supportcenter/C ... quired.htm I hope this helps. / comments

Thanks for your post. As long as [10.1.1.1\PROD].[ProdDB] is an online SQL Server database, then you should be able to connect to it to compare. Are you able to connect using the same credentials w...

0 votes

Thanks for your post. I'm not sure that method will work as you will need to 'map' the table to another table in the target. If the other db is null, then there won't be anything to map to. If you don't want to use another blank copy of the same database to map to, then you might be better off using the synchronize to scripts functionality. You can see an example of this in the patch SDK that you can get from here. The example that should be able to help you is 'StaticDataWithScriptsExample' I hope this helps. / comments

Thanks for your post. I'm not sure that method will work as you will need to 'map' the table to another table in the target. If the other db is null, then there won't be anything to map to. If you ...

0 votes

Thanks for your post. There aren't any restrictions on how you set up the project. You could simply have a single repository to store all the files, or you can have the flexibility of trunks and branches. It probably best to choose whatever method suits your project better. <http://stackoverflow.com/questions/16142/what-do-branch-tag-and-trunk-really-mean> / comments

Thanks for your post. There aren't any restrictions on how you set up the project. You could simply have a single repository to store all the files, or you can have the flexibility of trunks and br...

0 votes

Thanks for your reply. I think you may have encountered a known issue with the SQL Compare 8.50 release. Can you try the patch version and see if the problem is resolved? If not, let me know and we can look into this a bit further. You can get the patch from here: <http://www.red-gate.com/messageboard/viewtopic.php?t=11077> / comments

Thanks for your reply. I think you may have encountered a known issue with the SQL Compare 8.50 release. Can you try the patch version and see if the problem is resolved? If not, let me know and we...

0 votes

Thanks for your post. Can you confirm how you're generating the report? Are you using the SQL Compare 8 GUI to generate the report, or are you using the command line or API? Can you also confirm the exact version of SQL Compare 8 you're using? Also, when you open the report, are you opening it from the same location it was created in or have you deployed it? We create another folder of images which needs to also need to be deployed. / comments

Thanks for your post. Can you confirm how you're generating the report? Are you using the SQL Compare 8 GUI to generate the report, or are you using the command line or API? Can you also confirm th...

0 votes

Thanks for your post. I've recreated this, and it seems that we're not expecting the DEFAULT keyword to be supplied as a parameter, and are ignoring it. I have logged this as a bug with SQL Source Control (SOC-1873) Thanks for taking the time to report this. / comments

Thanks for your post. I've recreated this, and it seems that we're not expecting the DEFAULT keyword to be supplied as a parameter, and are ignoring it. I have logged this as a bug with SQL Source ...

0 votes

Thanks for your post. I've sent you an email through the support ticket we opened for you. Regards, / comments

Thanks for your post. I've sent you an email through the support ticket we opened for you. Regards,

0 votes

How can we help you today?

Chris Auckland

Comments