How can I transfer table?

Question

Post reply

How can I transfer table?

jilapi4u

SSC Enthusiast

Points: 123
More actions
May 20, 2009 at 10:53 pm

#209890

hello,
I need to port one table from one server to another. Does sql server have way to save a table as tab delimited/comma separated file? Is there a better way transport data?
Thank you in advance.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Eswin SSCrazy Eights Points: 8320 More actions · Answer 1

You can script it out......and run the script in the other server........

And always u can use import and export wizard.........

Tanx 😀

Clive Strong SSChampion Points: 11222 More actions · Answer 2

Clive Strong

SSChampion

Points: 11222

May 21, 2009 at 3:01 am

#998121

BCP is a great tool for this.

RP_DBA SSCertifiable Points: 5116 More actions · Answer 3

If it's a one-off, I'd go with the import/export wizard. If this is something you'll need to repeat down the road, you might consider writing code (i.e. SP) to handle it.

_____________________________________________________________________
- Nate

@nate_hughes

Greg Charles SSC-Forever Points: 45403 More actions · Answer 4

RP_DBA (5/21/2009)
If it's a one-off, I'd go with the import/export wizard. If this is something you'll need to repeat down the road, you might consider writing code (i.e. SP) to handle it.

...or an SSIS package.

Greg

Pradyothana Shastry SSCertifiable Points: 5211 More actions · Answer 5

Create one linked server ..then access your table and port to another

- Pradyothana http://www.msqlserver.com

Mayank Khatri SSCertifiable Points: 7984 More actions · Answer 6

I would say for one time purposes, Import/Export wizard

Erik Bitemo SSCrazy Points: 2062 More actions · Answer 7

Not (only) to marketing myself, but if you have PowerShell at hand, check http://getmssqldump.codeplex.com in terms of data movement. With this, you can extract the records into insert commands. It might help you.

-- Erik http://blog.rollback.hu

Perry Whittle SSC Guru Points: 234013 More actions · Answer 8

use a select script to generate an insert script for each row in the table and coupled with a create table script you have your table in portable format

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

kingmanjunath SSC-Addicted Points: 439 More actions · Answer 9

hi

there are lot more ways to transfer table from one instance to another instance.

1.import and export

2. run script on source instance, copy and excute the same script on other instance

3.bcp

4. snapshot

5.SSIS

etc

Goodluck

KingManjunath