Writing to a text file automatically

satraja2004

Hi All,

Is there any way to write the datas into a text file whenever datas are added to the database automatically.

Is OUTSTREAM used for this purpose, if yes, how can i use it?

kine

Why you need that? It is because some integration with another software?

You need to take into account, that the data can be changed hundred times per minute, there can be millions record etc.

Writing automatically each time into some file doesn't seem like good solution for me. Files are for off-line communication, if you need something on-line, there are other ways...

Belias

moreover, what if 2 users have to modify the same file automatically at the same time?
one of the users will receive an error because the file is already open...and this is only the "top of the iceberg"

satraja2004

Hi,

Sorry for the late reply.
I need to back up some 250 gb of data in 2 days from clients system.
so i thought of taking back up upto which is possible in these 2 days and writing the remaining into a text file whenever the user updates the database.

Is it a righ choice?
say me the best ways that i can acheive that task.
Is there any way to fastly back up those gb of datas within that given time?

DenSter

You can take a backup whenever you need, and it will contain whatever data the database contains at that time. If you are on the native C/SIDE database server then you won't be able to get the data that is entered after you take the backup.

If you are on SQL Server you can take a full backup now and transaction log backups after that, but in that case it's not going to take 2 days to backup and restore. SQL Server backups are usually very fast.

bbrown

Are you saying it's taking 2 days to backup 250 GB? Is this SQL? If so there are ways to backup that amount of data much faster.


One other difference between a NAV backup (*.fbk) and a SQL Backup:

A NAV backup will contain all data at the point the backup was started. A SQL backup will contain all data at the point the backup ended.

satraja2004

Hi BBrown,

I am not saying Baking up of 250 GB of datas taking 2 days,
client have given only 2 days to back up those 250 GB of datas.

we have to backup from navision only.

we have to do upgradtion, so only we need to back up the data first.

DenSter

If you're just now starting the upgrade, there is no need for an up to the minute backup. You still have the object merge to go, conversion, test upgrade, and then you do the final upgrade, which you should plan during a weekend anyway.

At that time you will need to take a new backup to build the final upgrade database, shut down the system until the final conversion is done. Putting serious development effort into a system that automatically writes data to a text file is the wrong thing to do here.

satraja2004

Hi Denster,

I exactly understood what i need to do, Thanks for ur help =D>

But i have a doubt, is it possible to take back up of 250 GB of datas in 2 days, is there any quick ways? #-o :-k

DenSter

Yes it is possible.

satraja2004

Hi Denster,

Thanks for ur help, =D> \:D/

Can u say me what is the way for it? [-o<

kriki

[Topic moved from 'General Chat' forum to 'NAV/Navision' forum]

DenSter

Yeah, start the backup process, and wait for it to be done.