Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
edu
Starting Member
3 Posts |
 Posted - 2005-10-16 : 15:26:51
|
| Hi all,Maybe someone can help me i got a SQL2000 DB that saves filenames from *.wav files in to a table. Those files are stored on a hd in different directorys and maps on the same server also the filenames are encrypted so there is no unity into the files. Is there a possibility to automaticly save those files I select to an external networkshare. I want to use the table for the copy proces and select the filenames from that table then i have to create some search command that finds those files on the disk and copys them to a network share.The problem is we are talking over more then 4000000 files and i only want the one i select with a special queuery.Does someone has experience with this or does anyone have an idea how to do this.thx in advanceEdu |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-17 : 00:12:53
|
so you have:1. a table with path2. you want sql to copy those .wav files to another network drive?I suggest don't. Use an application, windows scheduler, or batch file to do this. --------------------keeping it simple... |
 |
|
|
edu
Starting Member
3 Posts |
Posted - 2005-10-17 : 02:27:53
|
| Hi Jen,Txh for the anwser but i only got the file names and no path thats my problemedu |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-17 : 02:31:27
|
then you should also save the path in your table, curious, if there's no path, only the filename, how do you know here the files are? or they're currently in a default drive?quote:
Originally posted by edu
Hi Jen,Txh for the anwser but i only got the file names and no path thats my problemedu
--------------------keeping it simple... |
|
|
|
edu
Starting Member
3 Posts |
Posted - 2005-10-18 : 04:22:20
|
| Hi Jen,Thats my prob the product is made by a manufacturer and we can't change anything in the SQL server. The files are kept on a default drive.I also asked the manufacturer to ad one field extra into my table but he won't.....:(So the problem still excist. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-18 : 04:36:34
|
| vendors.. tsk tsk...so if i understand you right, you just want to have a backup of those .wav files in another drive?--------------------keeping it simple... |
|
|
|
HCLollo
Starting Member
49 Posts |
Posted - 2005-10-18 : 04:40:09
|
Well, Edu, if you know where the files are, where do you want to putthem, and (especially) you don't need an automated process, you couldeven go as far as to output the results of your query to a .bat andrun it You could create yourself an easy front-end for the query and theexecution of the batch maybe...Ok, probably it's not the really easy way, just something different  HCL"If it works fine, then it doesn't have enough features" |
|
|
|
|
|
|
|
|
Filecopy from SQL