Import/Export

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Import/Export

Import/Export

Rate Topic

Display Mode

Topic Options

Author

Message

Mansoor-602252

Posted Monday, July 07, 2008 6:27 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 11, 2009 2:59 AM
Points: 14, Visits: 50

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.................!

Post #529197

Andras Belokosztolszki

Posted Monday, July 07, 2008 6:29 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585

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

Post #529200

vidhya sagar

Posted Monday, July 07, 2008 6:56 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 2:45 AM
Points: 416, Visits: 521

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

Regards..Vidhya Sagar
SQL-Articles

Post #529236

Dugi

Posted Monday, July 07, 2008 7:00 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

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/

Post #529241

Mansoor-602252

Posted Monday, July 07, 2008 7:22 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 11, 2009 2:59 AM
Points: 14, Visits: 50

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.................!

Post #529276

A_A_R_T

Posted Monday, July 07, 2008 8:54 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 1:48 AM
Points: 276, Visits: 327

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.

Post #529387

kevin.kunz

Posted Monday, July 07, 2008 12:36 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 16, 2010 4:51 PM
Points: 125, Visits: 128

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

Post #529548

Andras Belokosztolszki

Posted Tuesday, July 08, 2008 1:22 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585

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

Post #529793

Mansoor-602252

Posted Tuesday, July 08, 2008 1:38 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 11, 2009 2:59 AM
Points: 14, Visits: 50

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.................!

Post #529804

« Prev Topic | Next Topic »

Permissions