January 28, 2009 at 12:52 pm
What is the best practice to either ftp or send 1 sql table to a requestor? Right now I create a new db, copy the table to this db, save the db & then put the backup of the db with the one table up on the ftp site.
Is there a better way? Another method that makes more sense for providing 1 table upon request?
Thanx!
January 28, 2009 at 12:58 pm
I guess it depends on what the end-user needs it for. Sending it as a single-table database works, if they want to query it and all that. If all they're looking for is a grid of data, I'd probably send it as an Excel file. If they want to import it into some other system, then XML might be better. It all depends on what it's for.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 28, 2009 at 1:54 pm
Thanx GSquared. I do need to send schema & data, so I will continue with what I am doing, just wondering if there was a way that made more sense for 1 sql table.
Thanx again!
Jude
January 28, 2009 at 2:54 pm
I handle this with a tool from xSQL called xSQL Data Compare.
You can compare the same table on two databases and script out the data differences or just script out the data and create table SQL.
I like this because it's text, which is easily viewed and applied to another database without much worry of version (2000, 2005, 2008) and it compresses down pretty well. Also if I can see their DB and they prefer, I could send them only the changes in the data, which is far quicker.
For example, I just exported a table with about a million rows. 250mb in text, compressed down to 10mb in winrar.
January 28, 2009 at 2:55 pm
A better way..who knows... currently the best way as we all will agree is the one that gives consistent results and works to your satisfaction with positive results...hehehe anyways.. Is it posible to have the table data imported or exported thru MSSQL. not sure if both servers have MSSQL or not. That i think might be an easier way once set up. Also what would it take to put Mssql on your destination server to then transfer the information cross the network just the same. Just food for thought. Good Luck.
-Darryl
DHeath
January 29, 2009 at 9:01 am
Thanx for all the answers folks. I actually do know how to bring something from server to server or export to another application.
I have an internal person making the request to give them 1 sql file zipped on hist local drive. He in turn puts it on a vendor's ftp site.
January 29, 2009 at 9:17 am
I'd BCP and then ZIP, easy to script. Easy to reload on the other side with a wizard.
January 30, 2009 at 6:49 am
thanx!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply