Import/Export

Question

Post reply

Import/Export

Mansoor-602252

SSC Veteran

Points: 294
More actions
July 7, 2008 at 6:27 am

#193518

Dear Friends
Can anybody tel me How to import/export tables in SQL Server 2005.
----------------------------------------------------------------------------------------------------
Mistakes are common.....and i am not an exception....
catch me if i am wrong....
MAK.................!

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

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

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 1

alikhan.mayana (7/7/2008)
Dear Friends
Can anybody tel me How to import/export tables in SQL Server 2005.

Have a look at the BCP utility http://msdn.microsoft.com/en-us/library/ms162802.aspx

But there are many different ways to export/import tables. What are you trying to do?

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 2

[font="Verdana"]Hi,

You can also try import \ export wizard.

*) Connect to the server and expand database folders

*) Right click on the db and click on All tasks

*) Then click on import \ export wizard and followup with the instructions[/font]

Regards..Vidhya Sagar
SQL-Articles

Dugi SSCoach Points: 17998 More actions · Answer 3

Yep we are here to help you just post the specific info what you are trying to do, of course that there are many ways how to do that, but be more specific, I'm sure that we or somebody helps you on professional way...

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Mansoor-602252 SSC Veteran Points: 294 More actions · Answer 4

Dear friends

I want to know the import/export tables from enterprise in SQL Server 2005.

I know that,we can import/export database but i want to know,

about tabels ?

----------------------------------------------------------------------------------------------------
Mistakes are common.....and i am not an exception....
catch me if i am wrong....

MAK.................!

A_A_R_T SSC Eights! Points: 900 More actions · Answer 5

Hi,

You can:

1) rightclick on a database

2) click tasks

3) click import or click export

Then it's possible to import / export the full database or you can just select the table(s) you'd like to be imported / exported.

kevin.kunz SSChasing Mays Points: 635 More actions · Answer 6

this is a simple wizard function, for which you can then create a scheduled task if you need to repeat it.

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 7

alikhan.mayana (7/7/2008)
Dear friends
I want to know the import/export tables from enterprise in SQL Server 2005.
I know that,we can import/export database but i want to know,
about tabels ?

This last message together with the title makes me wonder again about what you mean under import/export. Do you mean table level backup/restore (i.e. the "export" is a file with "bak" extension ?) When you say import/export a database, do you actually mean a backup? If so, you have two choices (that I'm aware of :)) You can either use filegroups, and backup entire filegroups, or, you could continue backing up the whole database, but use third party tools to do table level backup restored. In either case, you will need to ensure database consistency manually.

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Mansoor-602252 SSC Veteran Points: 294 More actions · Answer 8

Dear Friends

i got the solution for import/export tables in SQL SERVER 2005.

Thank U very much for helping me

----------------------------------------------------------------------------------------------------
Mistakes are common.....and i am not an exception....
catch me if i am wrong....

MAK.................!