Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import/Export Expand / Collapse
Author
Message
Posted Monday, July 7, 2008 6:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Monday, July 7, 2008 6:29 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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
Posted Monday, July 7, 2008 6:56 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 1:31 PM
Points: 416, Visits: 573
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
Posted Monday, July 7, 2008 7:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 3:44 AM
Points: 1,260, Visits: 3,424
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
Posted Monday, July 7, 2008 7:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Monday, July 7, 2008 8:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, December 1, 2014 7:31 AM
Points: 280, Visits: 394
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
Posted Monday, July 7, 2008 12:36 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Tuesday, July 8, 2008 1:22 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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
Posted Tuesday, July 8, 2008 1:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 »

Add to briefcase

Permissions Expand / Collapse