Solved

Export one table of a SQL 2005 Database

Posted on 2010-09-06
7
464 Views
Last Modified: 2012-05-10
Looking to export just one table of a SQL 2005 database.  Is it possible to export the data and have import into a temp Database that I have created on a seperate instance on the same physicall server.  The destination server is a 2008 instance.
0
Comment
Question by:GSLElectric
  • 4
  • 3
7 Comments
 

Author Comment

by:GSLElectric
ID: 33614734
these are basically the steps I've followed to this point.  It seems to export successful, but no rows of data go with it.
sql-exports-steps.docx
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33614750
Kindly confirm

1. Whether you have records in your source table
2. You have transferred records to the correct database and verifying it over there.
0
 

Author Comment

by:GSLElectric
ID: 33614759
the source table does have records.  That has been confirmed it doesn't create a destination table in the new database and therefore there isn't any data in there as well.  Here is the report that was created when the export task was created.


The execution was successful

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

- Validating (Success)

- Prepare for Execute (Success)

- Pre-execute (Success)

- Executing (Success)

- Copying to [dbo].[PRTH] (Success)
      * 0 rows transferred

      Messages
      * Information 0x402090df: Data Flow Task 1: The final commit for the data insertion in "component "Destination - PRTH" (154)" has started.
       (SQL Server Import and Export Wizard)
      
      * Information 0x402090e0: Data Flow Task 1: The final commit for the data insertion  in "component "Destination - PRTH" (154)" has ended.
       (SQL Server Import and Export Wizard)
      

- Post-execute (Success)
      Messages
      * Information 0x4004300b: Data Flow Task 1: "component "Destination - PRTH" (154)" wrote 0 rows.
       (SQL Server Import and Export Wizard)
      
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 33614770
Can you try transferring records into a new temp table say test in that particular database to see whether it works or not..
0
 

Author Comment

by:GSLElectric
ID: 33614827
do you follow those same steps in order to do that?
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33614884
Able to successfully move records in my system using the above steps..
That's why asking you to ensure that things are followed correctly.
0
 

Author Closing Comment

by:GSLElectric
ID: 33614943
It was a security issue.  I had to use the SA account to make it work.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now