Re: Convert 4D data MSSQL

2017-09-07 Thread Charles Miller via 4D_Tech
One more thing. If you can create a true stored procedure in MS sql server. and execute by passing in that would be faster ads well Try this link https://technet.microsoft.com/en-us/library/ It will show you transact sql server commands etc On Thu, Sep 7, 2017 at 5:21 PM, Justin Will via 4D_Tech

RE: Convert 4D data MSSQL

2017-09-07 Thread Justin Will via 4D_Tech
Thanks Chuck, I'll give that a try. Perhaps batches of 25k records as arrays will work and speed things up. > You might try to use arrays to update and not individual records Justin ** 4D Internet Users Group (4D iNUG) FAQ: ht

Re: Convert 4D data MSSQL

2017-09-07 Thread Arnaud de Montard via 4D_Tech
> Le 7 sept. 2017 à 17:42, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > I think this is what SQL EXPORT DATABASE and SQL EXPORT SELECTION do. You > might have some issues with date/time fields as well as object fields. Unfortunately these commands have been written in a 4d-

RE: Convert 4D data MSSQL

2017-09-07 Thread Justin Will via 4D_Tech
Jeffrey, Thank you, I was not aware of SQL EXPORT DATABASE. I might be able to make it work by dumping to an intermediate SQL database and then converting the data to the slightly modified schema from there. Thanks Justin **

Re: Convert 4D data MSSQL

2017-09-07 Thread Randy Jaynes via 4D_Tech
Sure looks like it! I wasn’t even aware of this command in 4D, but it calls it a ‘dump’, so that’s the kind of text file I would expect this to create. Randy -- Randy Jaynes Senior Programmer and Customer Support http://printp

Re: Convert 4D data MSSQL

2017-09-07 Thread Jeffrey Kain via 4D_Tech
I think this is what SQL EXPORT DATABASE and SQL EXPORT SELECTION do. You might have some issues with date/time fields as well as object fields. -- Jeffrey Kain jeffrey.k...@gmail.com > On Sep 7, 2017, at 11:40 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Maybe you can

Re: Convert 4D data MSSQL

2017-09-07 Thread Randy Jaynes via 4D_Tech
Maybe you can write 4D code to create blocks of insert statements in a text file like LOCK TABLES `CatalogPricing` WRITE; INSERT INTO `CatalogPricing` (`catPriceID`, `catPriceCatalogID`, `catPriceQty`, `catPriceAmount`, `catPriceStatus`) VALUES (2,2,1,15.00,'1'), (7,3,1,15.00,'1

Re: Convert 4D data MSSQL

2017-09-07 Thread Chuck Miller via 4D_Tech
You might try to use arrays to update and not individual records Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutio