How to archive data from sqlserver to flat files

Question

0.00/5 (No votes)

See more:

Hello,

I have one table like 'customer' with have 10 records. i want to archive in 5 records.
Finally i want to execute that table like 'select * from customer, then it will display 10 records(5 records are in customer and 5 records are in arching location).
is it possible to get all records..?

can you please help me.
thanks in advance

Posted 17-Oct-11 1:28am

K N R

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

shijuse · Answer 1 · 2011-10-17T03:02:00

Solution 1

1) If you archiving the table to the same server and different database, you can just retreive the results with a database.dbowner synatx. For Eg: -

select * from [Servername].[OriginalDatabase].dbo.[OriginalTable]
union all
select * from [Servername].[ArchivalDatabase].dbo.[ArchivedTable]

2) If the archived db is in different server. Please use the linked server option in sql and run the above query.

Posted 17-Oct-11 3:02am

shijuse

Comments

K N R 17-Oct-11 9:28am

hey shijuse,
i am not maintain archive data in same database or another database. It will be another like notepad or xml files.

shijuse 17-Oct-11 9:37am

How you are writting archived data to notepad/xml (BCP/For xml command?)

K N R 17-Oct-11 9:56am

ya am using bcp command

How to archive data from sqlserver to flat files

1 solution

Solution 1

Add your solution here

Preview 0

How to archive data from sqlserver to flat files

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us