February 21, 2007 at 11:02 am
I have a coupel tables in my instance of SQL Server that I would like to FTP to somebody else. Is there an easy way to send that data for just those select tables without exporting to a CSV or something and letting them import it? I want to create something to send that will maintain the tables structure and data basically for them to import. Thanks.
February 21, 2007 at 12:25 pm
If its a whole database then its probably easiest to back it up and send the backup across.
Otherwise you can use somthing like BCP to get the data out and save scripts from enterprise manager however this will require the other user to run them by hand and use BCP to import the data.
Finally you can try a tool like SQL Packager from Red Gate http://www.red-gate.com/products/SQL_Packager/index.htm which allows you to package up parts of your database as an executable and ftp that across (A 14 day free trial is availible).
Hope this helps,
- James
--
James Moore
Red Gate Software Ltd
February 22, 2007 at 11:03 am
To include the necessary schema, XML is probably the way to go. You could also use an SSIS Raw file which is a native file format for SSIS to import and export.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply