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 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 **********************************************************************
