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'),
(17,7,1,14.95,'1'),
(19,9,1,14.95,'1'),
(20,10,1,14.95,'1'),
(21,5,1,14.95,'1'),
(22,11,1,14.95,'1'),
(23,12,1,14.95,'1'),
(24,13,1,14.95,'1'),
(25,14,1,14.95,'1'),
(26,15,1,14.95,'1'),
(27,16,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.
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
**********************************************************************
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:[email protected]
**********************************************************************
