[EMAIL PROTECTED] wrote: > What's the best way to share a half dozen sql server 2000 tables that contain > data with an offsite > contractor? I was going to export to MS Access and send a file. Any other > thoughts? >
If they have SQL Server on their end, and you just want to provide them with the tables exactly as they are in your database, I would look at using something like Aqua Data Studio, which can do a dump of the tables which includes CREATE TABLE statements and INSERT statements for the data. Then you can make sure all of the PKs and FKs are in place as you expect them to be, and the datatypes will be the same. An export into Access and subsequent import into SQL would not ensure that. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
