Comments
Sort by recent activity
It didn't make 8.2. In retrospect this would have been a little unusual, as point releases are generally reserved for bug fixes, as indeed this one was. The most likely scenario is that it will be in 9.0, which is scheduled tentatively for Q4.
It must be noted that adding IF EXISTS statements around each action isn't the ideal way of working, and cannot be expected to work in all cases. Is there any reason why you can't generate the script from the client's schema?
David / comments
It didn't make 8.2. In retrospect this would have been a little unusual, as point releases are generally reserved for bug fixes, as indeed this one was. The most likely scenario is that it will be ...
Did you know that your clients can create and email you with a schema snapshot using a free tool, SQL Snapper? This can be downloaded from http://labs.red-gate.com/index.php/Main_Page
With a schema snapshot you can create an upgrade script that is specific to the customer.
Is this something that will solve your problem?
David Atkinson
Red Gate Software / comments
Did you know that your clients can create and email you with a schema snapshot using a free tool, SQL Snapper? This can be downloaded fromhttp://labs.red-gate.com/index.php/Main_Page
With a schema ...
If you want to recreate the schema as a database, simply create an empty database:
CREATE DATABASE newdb
then use SQL Compare, putting the snapshot as the source and newdb as the target. Obviously you don't have any data. You can save your data to script files using SQL Data Compare pro and use the same mechanism to synch this with your database, although we'd only recommend you do this for lookup tables.
Hope this helps,
David / comments
If you want to recreate the schema as a database, simply create an empty database:
CREATE DATABASE newdb
then use SQL Compare, putting the snapshot as the source and newdb as the target. Obviously ...
tatvasoft53 wrote:
Hi All.
when we compare 2 database and redgate generate syncronize script. Now i want this script to run as many times. means the script must check for the object exist OR not instead of directly alter statement.
By default redgate generate script which run only 1 time. when i try to run script second time then it will display error because of again create statement without drop the procedure.
can anyone please tell me is it possible to generate sql script that check the procedure, function,... exist and if it exist then drop it and recreate it?
Thanks in advance.
Can I ask why you want to dro and recreate it if it exists?
David Atkinson
Product Manager
Red Gate Software / comments
tatvasoft53 wrote:
Hi All.
when we compare 2 database and redgate generate syncronize script. Now i want this script to run as many times. means the script must check for the object exist OR not ...
If you generate a migration script from database A to B, it will have CREATE statements for new objects and ALTER statements for existing objects. If all your clients are using databases with the same schema, I can't see why SQL Compare's scripts shouldn't run successfully without having to drop and recreate objects. Or do I misunderstand your requirement?
David Atkinson
Product Manager
Red Gate Software / comments
If you generate a migration script from database A to B, it will have CREATE statements for new objects and ALTER statements for existing objects. If all your clients are using databases with the s...
We don't have precise benchmarking figures yet, but we're working on that. I'd say it currently takes five minutes to index 1000 objects. Could you run the following query on a typical database and let us know what it returns?
SELECT RTRIM(SUM(LEN(text))) + ' total text size across ' + RTRIM(COUNT(DISTINCT id)) + ' objects' FROM sys.syscomments AS s
Thanks!
David / comments
We don't have precise benchmarking figures yet, but we're working on that. I'd say it currently takes five minutes to index 1000 objects. Could you run the following query on a typical database and...
We're currently working on improving the performance. Do you have a view on what you would consider a reasonable delay for this one-time operation?
We're also hoping to add a progress indicator that will show the remaining work.
David Atkinson
Red Gate Software / comments
We're currently working on improving the performance. Do you have a view on what you would consider a reasonable delay for this one-time operation?
We're also hoping to add a progress indicator tha...
The trouble with resetting selections when the target database is changed is that you might legitimately want to synchronize numerous targets with the same changes. If you've spent a long time meticulously selecting which objects you want to synchronize, it would be a big ask to have to duplicate this work.
David Atkinson
Product Manager
Red Gate Software / comments
The trouble with resetting selections when the target database is changed is that you might legitimately want to synchronize numerous targets with the same changes. If you've spent a long time meti...
We will be supporting this officially in the next major release. In the meantime you can sign up for the early access program at www.red-gate.com/Azure
We'll direct you to a beta version of our SQL Azure tools.
David Atkinson
Red Gate Software / comments
We will be supporting this officially in the next major release. In the meantime you can sign up for the early access program at www.red-gate.com/Azure
We'll direct you to a beta version of our SQL...
Thanks for the idea. It's a good one and we've had such suggestions across all our products that display SQL! Unfortunately it's not designed to be used as a 'service' to other apps just yet, but hopefully one day that will change!
David Atkinson
Product Manager
Red Gate Software / comments
Thanks for the idea. It's a good one and we've had such suggestions across all our products that display SQL! Unfortunately it's not designed to be used as a 'service' to other apps just yet, but h...