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
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
> 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-
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
**
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
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
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
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
Does anyone have any advice on converting a 4D Database to MSSQL. The database
is quite large at 75+gb of data and doing the conversion with an SQL Login and
looping the 4D records using Inserts into MSSQL is taking quite literally days
to convert.
Any ideas are welcome.
Thanks
Justin Will
**
9 matches
Mail list logo