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 |
|
sqldba2k6
Posting Yak Master
176 Posts |
 Posted - 2007-04-09 : 16:18:50
|
| I am designing a data flow archieture.I need the suggestions.What are the advantages of storing data of the flat files to sqlserver. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-09 : 23:34:02
|
huh?one advantage of putting data in a database is that you can query it efficiently. It's difficult to query a flat file efficiently - you pretty much have to scan the file.but if you are a dba as your name indicates you should know this already...
www.elsasoft.org |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-10 : 01:39:01
|
| Homework question? How many marks?I can think of one big advantage...I don't care how/where data is stored by SQL Server. I just need to care about what data is being stored.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
cmdr_skywalker
Posting Yak Master
159 Posts |
Posted - 2007-04-10 : 02:23:19
|
| Why do you want to store it somewhere in the first place aside from being a flat file? Isn't the flat file enough? Your answer in the first question is the list of business need you are trying to meet.By the way, if you only need to compress/encrypt the file, you need Winzip, WinRAR or ARJ and not SQL Server.Hope that helps.May the Almighty God bless us all!www.empoweredinformationsystems.com |
|
|
|
|
|
|
data flow