Activity overview
Latest activity by brigzy
I find there are a number of views that error when sp_refreshview is called, it would be really useful to be able to disable refresh of particular views.
Please could be logged as an enhancement request? / comments
I find there are a number of views that error when sp_refreshview is called, it would be really useful to be able to disable refresh of particular views.
Please could be logged as an enhancement re...
I found problem is caused when a new project is created, the compare is run, but the Sync Wizard has not been run.
So I am over that hurdle and now the script is created just fine.
Indeed the /pr aproach has removed all the unwanted sp_refreshview statements from the scripts. / comments
I found problem is caused when a new project is created, the compare is run, but the Sync Wizard has not been run.
So I am over that hurdle and now the script is created just fine.
Indeed the /pr a...
Michelle Taylor wrote:
You might find that SQL Compare produces less refreshview statements if you create the script through the GUI (or if you need to use the command line, create a project in the GUI, save the project, and use the /pr: switch on the command line to use the project to generate the script).
The extra view refreshes are a known issue (SC-4542) which we'll hopefully get fixed soon.
Ok thankyou, I am trying the /pr switch
The GUI project finds differences ok.
When using /pr switch however I receive message :
Error: The selected objects are identical or no objects have been selected in the comparison. / comments
Michelle Taylor wrote:
You might find that SQL Compare produces less refreshview statements if you create the script through the GUI (or if you need to use the command line, create a project in t...
Michelle Taylor wrote:
/scriptencoding is the command line switch you're looking for - see the docs for more details.
Ah yes that would have done it..
Many Thanks / comments
Michelle Taylor wrote:
/scriptencoding is the command line switch you're looking for - see the docs for more details.
Ah yes that would have done it..
Many Thanks
Michelle Taylor wrote:
You can switch to a different text encoding for your script to avoid the byte order marker problem - if you're just saving the script from a synchronization in the UI, the setting is in Application Options, accessible from the Tools menu.
I am new to SQLCompare just today, so I appologise if I miss the obvious...
The script is being generated by SQLCompare (command line), so I am not sure the options you mention are available.
Using SQLCMD as an alternative to OSQL is working solution for me.
I do have a problem at the momentthough see : post http://www.red-gate.com/messageboard/viewtopic.php?t=9653 / comments
Michelle Taylor wrote:
You can switch to a different text encoding for your script to avoid the byte order marker problem - if you're just saving the script from a synchronization in the UI, the ...
Disable sp_refreshview
Hi
I am having trouble as sp_referesh view is included in the script generated by SQLCompare command line.
When running the script on the destination server\database, the script errors as the view ...
brigzy wrote:
Hi
when running an SQL script generated by SQLCompare we get this error :
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> Msg 102, Level 15, State 1, Server PARTNER-DEV, Line 1 Incorrect syntax near 'ï'. /*
Run this script on:
Partner-Dev.partner_chall - This database will be modified
to synchronize it with:
Partner-Dev.rdb_partner_chall
You are recommended to back up your database before running this script
Script created by SQL Compare version 8.1.0 from Red Gate Software Ltd at 24/09/2009 11:44:10
*/
SET NUMERIC_ROUNDABORT OFF
1> 2>
OSQL seams to see some odd characters at the beginning of the file?
I found I am ok if I use sqlcmd instead, which supports UTF-8. / comments
brigzy wrote:
Hi
when running an SQL script generated by SQLCompare we get this error :
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> Msg 102, Level 15, State 1, Server PARTNER-DEV, Line...
Hi
when running an SQL script generated by SQLCompare we get this error :
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> Msg 102, Level 15, State 1, Server PARTNER-DEV, Line 1 Incorrect syntax near 'ï'. /*
Run this script on:
Partner-Dev.partner_chall - This database will be modified
to synchronize it with:
Partner-Dev.rdb_partner_chall
You are recommended to back up your database before running this script
Script created by SQL Compare version 8.1.0 from Red Gate Software Ltd at 24/09/2009 11:44:10
*/
SET NUMERIC_ROUNDABORT OFF
1> 2>
OSQL seams to see some odd characters at the beginning of the file? / comments
Hi
when running an SQL script generated by SQLCompare we get this error :
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> Msg 102, Level 15, State 1, Server PARTNER-DEV, Line 1Incorrect synt...