Exporting data form sql 2003

I would like to export data from a table in SQL 2003 in a way that I can import it again transparently.

Some fields like dates just export in ways that the info is not preservered.

robrodpAsked:
Who is Participating?
 
sudheeshthegreatConnect With a Mentor Commented:
csv wouldn't exactly store the date formats correctly. may have problems with mm/dd and dd/mm. export to excel or access and then you can import it back similarly.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
You can export it using Import / Export wizard to a .CSV file
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
robrodp,
> in a way that I can import it again transparently.
If you wanna import it again back to the same server, then you can take a backup, and restore the database again
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
robrodpAuthor Commented:
I do not want to backupthe database just one table
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Then it is better to Export the data as a CSV file
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
One more options is to create another table with the same structure in the same database but with different name. Whenever you feels to restore then you can delete/rename the current, rename the backedup table to 'current'
Something like

INSERT INTO UrTable_Bak
SELECT * FROM urTable

--For restoration
exec sp_rename 'urTable', 'urTable_old'
exec sp_rename 'urTable_bak','urTable'
 

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.