> You should be able to do this through DTS, if the SQL Server 2000 machine > can connect to the SQL Server 7 machine. If that's not possible, you can > install both on a single machine by installing a default SQL Server 7 > instance, then installing a named SQL Server 2000 instance. > > Dave Watts, CTO, Fig Leaf Software
Thanks Dave.... DTS failed (copying all objects) with a complaint about the "bigint" datatype (which I don't think I even use). I'm now runing DTS again but only copying tables and their data. So far so good...175K of about 500K records converted. I'll just be stuck with adding back in my PKs/FKs/indexes (could be worse)....and should be quicker than what you've laid out above Dave.....but if it comes down to it.... ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227366 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54