tag:blogger.com,1999:blog-497787815177352569.post7783440908613505058..comments2024-01-03T08:55:04.827-05:00Comments on SQL Anywhere: UNLOAD SELECT BULK INSERTBreck Carterhttp://www.blogger.com/profile/15975598564711761434noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-497787815177352569.post-48622870778223542132011-10-18T00:27:16.408-04:002011-10-18T00:27:16.408-04:00Volker can you please send me a private email ARMD...Volker can you please send me a private email ARMD at pacbell.net.<br />I have a question about the Sql anywhere 5.X version and unload to MS sql and bulk insert.<br />Thanks<br />AlexAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-497787815177352569.post-91107510710432199992011-05-17T11:34:28.267-04:002011-05-17T11:34:28.267-04:00Breck, thanks again - it works great:)
Two sugges...Breck, thanks again - it works great:)<br /><br />Two suggestions I'd like to make:<br /><br />1. I'd fill the temporary table right at the start - this makes it easier to use one central place to add the relevant tables - particular if one does not want to export all (since they do not exist in MSS or to limit for testing purposes).<br /><br />2. TRUNCATE TABLE fails for tables with FK relationships (even if they are empty, methinks) in MSS. Therefore I have used DELETE FROM and let it run in descending logical (i.e FK) order. In order to use that (as I had created the MSS tables in logical order), I added a creation_date to the temporary table and filled it with data from MSS sysobects.crdate field (by means of a proxy table to sysobects).<br /><br />You see, you've delivered a real good starting point:)<br /><br />VolkerAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-497787815177352569.post-48077547042465615832011-05-16T03:36:02.812-04:002011-05-16T03:36:02.812-04:00Breck, you saved my day (or week):)
Exporting lot...Breck, you saved my day (or week):)<br /><br />Exporting lots of SA tables to MS SQL is something that's on my schedule currently, and your script based-approach will prevent me from having to fiddle around with that funky Data Transfer Wizard...<br /><br />BIG THANKS!<br /><br />Regards<br />VolkerAnonymousnoreply@blogger.com