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://printpoint.com <http://printpoint.com/> • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964 > On Sep 7, 2017, at 11:42 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com > <mailto:4d_tech@lists.4d.com>> wrote: > > 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 <mailto: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 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'), >> (9,4,1,14.95,'1'), >> (12,6,1,14.95,'1'), >> (14,8,1,14.95,'1'), >> [...] >> UNLOCK TABLES; >> >> Then just import/run the SQL files in MSSQL. >> >> There are some data types you might have to deal with in other ways, but >> this might handle most of what you need. > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
