Comments
Sort by recent activity
Thanks Mike, I have downloaded it and can now use the updated SQL Compare and SQL Data Compare. / comments
Thanks Mike, I have downloaded it and can now use the updated SQL Compare and SQL Data Compare.
Okay Mike, thanks for the information.
Regards,
Martin. / comments
Okay Mike, thanks for the information.
Regards,
Martin.
Okay, thanks for your help.
Regards,
Martin. / comments
Okay, thanks for your help.
Regards,
Martin.
Thanks Allen:
As Comparison SDK is not available for v11, I will have to continue to use v10 to create the snapshots.
Regards,
Martin. / comments
Thanks Allen:
As Comparison SDK is not available for v11, I will have to continue to use v10 to create the snapshots.
Regards,
Martin.
Can anyone help me with this???
Thanks,
Martin. / comments
Can anyone help me with this???
Thanks,
Martin.
Michelle:
Thank you for the detailed answer. Yes, that does meet my needs. Simple when you think about it!
The other day I took the SQL Compare 7 survey, maybe you could add this to the list of ideas for the new version.
It would be great to be able to synchronize a database to/from a single script file as is done with the snapshot.
Thanks again,
Martin. / comments
Michelle:
Thank you for the detailed answer. Yes, that does meet my needs. Simple when you think about it!
The other day I took the SQL Compare 7 survey, maybe you could add this to the list of ide...
Michelle:
Michelle Taylor wrote:
If you want the actual script which creates all the objects in the correct order, just compare the script files with an empty live database and save the resulting synchronization script.
Thanks, I don't know why I didn't think of that!!
Regards,
Martin. / comments
Michelle:
Michelle Taylor wrote:
If you want the actual script which creates all the objects in the correct order, just compare the script files with an empty live database and save the resulting ...
Petey:
petey wrote:
The answer is probably no, but could you pls explain further, as I fail to see the point of password protecting a file without encrypting its' contents. Thanks.
Sure. What I'm looking for is a way to make a backup that can't be restored on another system without entering a password, but I don't need to go as far as actually encrypting the data. So, if someone with knowledge of SQL backups decides to access the file via an API and extract the data, that's not a problem. It's the casual copy/restore I'm trying to address.
Thanks for your comments,
Martin. / comments
Petey:
petey wrote:
The answer is probably no, but could you pls explain further, as I fail to see the point of password protecting a file without encrypting its' contents. Thanks.
Sure. What I...
Thanks to both Brian and petey.
With these replies I can get up and running, so I'm off to the Red-gate store!!
Regards,
Martin. / comments
Thanks to both Brian and petey.
With these replies I can get up and running, so I'm off to the Red-gate store!!
Regards,
Martin.
Petey:
petey wrote:
Yes. You could set up a scheduled task using Windows (Accessories > System Tools > Scheduled Tasks).
If you want to use the extended stored procedure, you would need to write an app, or use Active Scripting, to connect to the server and run the extended stored procedure.
If using the command line interface, enter the path and file name of the command line executable (sqlbackupc.exe) together with the required parameters. You can use the command line interface only for local servers.
Where can I find information about writing my own app to access the extended stored procedure? I am a proficient C# programmer so this shouldn't be too dificult, it's the calling the XSP I'm not sure of.
Also the command line is an option I hadn't thought of. These are stand alone machines so the local server is not a problem.
Thanks,
Martin. / comments
Petey:
petey wrote:
Yes. You could set up a scheduled task using Windows (Accessories > System Tools > Scheduled Tasks).
If you want to use the extended stored procedure, you would need to write ...