Activity overview
Latest activity by crescentDB
sergio:
Thanks for the reply. Is there a way to automate the process? Say I have a table with 100,000 rows and I want to spilt it into *.sql scripts with 25,000 each... Do I have to manually go in and add where clauses to get the desired result? It'd be nice to have an automated option.
And what does the "Split transactions / batch operations" option do? I'm still not able to get that to work (it's still one large script file with a single BEGIN TRANSACTION ... COMMIT TRANSACTION block).
Thanks. / comments
sergio:
Thanks for the reply. Is there a way to automate the process? Say I have a table with 100,000 rows and I want to spilt it into *.sql scripts with 25,000 each... Do I have to manually go in ...
Splitting one large script into several smaller ones
Hi.
Is it possible for SQL Data Compare to generate several smaller *.sql scripts (that need to be executed in order) instead of just having one large script?
I tried using the "Split transactions ...