Is this right if i will do my project this way?..

Question

Is this right if i will do my project this way?..

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

enriquezreyjoseph Ten Centuries Points: 1291 More actions · Answer 1

Brandie Tarvin (10/3/2013)
enriquezreyjoseph (10/2/2013)
my classes contains a connectionString to a different server, because every server contains a different databases, so meaning in every classes i have different connectionString that will open the connection to a certain database....and mydataset contains all tables in a certain database...
Given this information, I think the graph is seriously wrong. Either each class leads to a server and a set of tables within that server's database, or you have 3 classes acting upon one database's information and then sending information to two other servers.
How well do you know the data? And what exactly are you trying to do here, because your explanation doesn't tell us what you're doing. It just tells us a very generalized layout.
And why do you need classes to point to a dataset anyway? You should be able to derive a dataset independently of the class. The class should only define what to do with that data once you have it.

wat i mean is that my class contains all the data in the dataset..i wrongly pointed the arrow sorry...

Jeff Moden SSC Guru Points: 1003871 More actions · Answer 2

enriquezreyjoseph (10/3/2013)
Koen Verbeeck (10/3/2013)
Brandie Tarvin (10/3/2013)
Jeff Moden (10/3/2013)
Lynn Pettis (10/3/2013)
enriquezreyjoseph (10/2/2013)
Jeff Moden (10/2/2013)
enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day:-)
Is this right if i will do my project this way?
Please see my attachment
If it's strictly an ETL project, maybe. Otherwise, probably not.
What do you mean ETL project??...
"Every Person has it's own weaknesses, be brave even though you are not, no one can tell the difference" ~ Sir Bernard Tan
ETL - Extract, Transform, Load
Usually done when moving data from OLTP databases to DW databases.
Or moving data from external sources to databases.
Or moving data from databases to external sources.
Or moving data from external sources to external sources 😀
huh??...

It's pretty much like listed above. Moving data to or from usually (but not necessarily) disparate sources and targets is generally classified as ETL unless it's a "backup" (which, I suppose, could be classified as a form of ETL especially if used to move data from one system to another).

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Jeff Moden (10/3/2013)
enriquezreyjoseph (10/3/2013)
Koen Verbeeck (10/3/2013)
Brandie Tarvin (10/3/2013)
Jeff Moden (10/3/2013)
Lynn Pettis (10/3/2013)
enriquezreyjoseph (10/2/2013)
Jeff Moden (10/2/2013)
enriquezreyjoseph (10/1/2013)
Hi Everyone..I hope everyone is having a nice day:-)
Is this right if i will do my project this way?
Please see my attachment
If it's strictly an ETL project, maybe. Otherwise, probably not.
What do you mean ETL project??...
"Every Person has it's own weaknesses, be brave even though you are not, no one can tell the difference" ~ Sir Bernard Tan
ETL - Extract, Transform, Load
Usually done when moving data from OLTP databases to DW databases.
Or moving data from external sources to databases.
Or moving data from databases to external sources.
Or moving data from external sources to external sources 😀
huh??...
It's pretty much like listed above. Moving data to or from usually (but not necessarily) disparate sources and targets is generally classified as ETL unless it's a "backup" (which, I suppose, could be classified as a form of ETL especially if used to move data from one system to another).

You could possibly extend ETL to include a backup or replication or mirroring or logshipping, but wouldn't that be more like EL and not ETL?

:-D;-)

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events