Comments
Sort by recent activity
And I just tried to re-use the newly created scripts. No luck. I'll try scripting without the option to split the script into multiple transactions next time around, but to me if I have the option to generate a SQL Script, I should be able to use that script to push changes to the database without needing Data Compare. / comments
And I just tried to re-use the newly created scripts. No luck. I'll try scripting without the option to split the script into multiple transactions next time around, but to me if I have the option ...
Brian Donahue wrote:
How do you re-use the scripts? Are you running them in another tool, like sqlcmd?
I'm using SQLCMD to run the scripts. Otherwise, what is the point of saving out the data compare to a script. I want the ability to re-create an empty set of databases and run just the scripts to populate them with a base set of data to use for testing and development work.
Obviously that data will change in small ways over time, but populating a working set is a good start. I'm almost positive that this worked properly in a prior version of Data Compare. / comments
Brian Donahue wrote:
How do you re-use the scripts? Are you running them in another tool, like sqlcmd?
I'm using SQLCMD to run the scripts. Otherwise, what is the point of saving out the data ...
Brian Donahue wrote:
I'm trying to reproduce this - what is the problematic BLOB type (image, text, binary), version of SQL Server, and the size of BLOBS going in?
It doesn't seem to use or need the pointer for nvarchar(max) on SQL 2008, but it does declare @pv again in every block of split transactions.
Pretty sure it's with XML or Text data. This is coming from SQL Server 2005 going to SQL 2012 (though that ideally shouldn't matter). When I pulled up one of the smaller scripts that failed, I noticed that the only DECLARE @pv prior to using it was not in the same transaction block. When I ran the Data Compare directly, it worked and I figured the script would work as well, but I can't seem to run the saved script.
I'll try another data compare to see if that makes a difference. I was just hoping to avoid that as the generated scripts are hundreds of MB and if I can't reuse the scripts, that makes the process a little less useful. / comments
Brian Donahue wrote:
I'm trying to reproduce this - what is the problematic BLOB type (image, text, binary), version of SQL Server, and the size of BLOBS going in?
It doesn't seem to use or need...
I believe it is related to that. I'm using Data Compare to script out entire customers from our multi-tenant database. It works great for the most part, but generates very large files. From what I can tell in one of the smaller files, the DECLARE @pv section is at the very top of the file and is followed by several commands to disable constraints. Those all have GO to separate the batches, which means that when the first actual section is run to insert data, there is no variable declared to handle the BLOB data. / comments
I believe it is related to that. I'm using Data Compare to script out entire customers from our multi-tenant database. It works great for the most part, but generates very large files. From what I ...
Thanks, Paul. I look forward to giving it a try. It doesn't come up often in our day to day use, except recently with the project I'm working on that makes heavy use of MERGE.
-Peter / comments
Thanks, Paul. I look forward to giving it a try. It doesn't come up often in our day to day use, except recently with the project I'm working on that makes heavy use of MERGE.
-Peter
Having the same problem on the latest beta and the first beta completely stopped working tonight. Any news on a new beta for download? In its current form, SQL Prompt 5 EAP is unusable for me and with the prior beta not working, I'm reverting back to v4 until a new release comes out. / comments
Having the same problem on the latest beta and the first beta completely stopped working tonight. Any news on a new beta for download? In its current form, SQL Prompt 5 EAP is unusable for me and...
markv - sadly that didn't work for me - tried it last night. [image] Rolled back to v4 afterwards and was pleasantly surprised to find that my snippets from that version were still intact. paul - shot you a message back, though I realize it's pretty late already if you're in the UK office. I'm running on v4 for now so have some time. / comments
markv - sadly that didn't work for me - tried it last night. Rolled back to v4 afterwards and was pleasantly surprised to find that my snippets from that version were still intact.paul - shot you...
Any news on a new release? The second EAP hangs my SSMS window on SQL 2008 R2 when I connect to a Server. With the first EAP having quit just now, I can't continue testing. I am not quite sure what to send or if there is anything to send at this time. Just know that this release doesn't work for me and I've seen some other posts here as well about problems with the second EAP. / comments
Any news on a new release? The second EAP hangs my SSMS window on SQL 2008 R2 when I connect to a Server. With the first EAP having quit just now, I can't continue testing. I am not quite sure wh...
I had to roll back. I couldn't even start using SSMS today. Not sure it's 100% related, but I didn't have that problem with .224. Re-installed that version and I can work again. / comments
I had to roll back. I couldn't even start using SSMS today. Not sure it's 100% related, but I didn't have that problem with .224. Re-installed that version and I can work again.
I'm getting similar errors. Some out of memory warning when trying to hit more than one DB. Any way to roll back or get a different build?
-Peter / comments
I'm getting similar errors. Some out of memory warning when trying to hit more than one DB. Any way to roll back or get a different build?
-Peter