Exporting\Importing sql server 2000 data and structure
-
Hello, I am required to supply q programtic solution to import\export the data and the struture (also foreign keys and views) of a table that resides at the sql server using c#. Is there a easy, auto generated way to do so ? I already let visual studio 2005 generate the code for the adapters of the various tables in order to retrieve\update the data. Thanks, Berlus
-
Hello, I am required to supply q programtic solution to import\export the data and the struture (also foreign keys and views) of a table that resides at the sql server using c#. Is there a easy, auto generated way to do so ? I already let visual studio 2005 generate the code for the adapters of the various tables in order to retrieve\update the data. Thanks, Berlus
Berlus wrote:
I already let visual studio 2005 generate the code for the adapters
Which means you have no idea how your database is structured. These bloody auto generate things are a disaster and should be taken out and shot. Get into query analyser and look into the system table in the master database. Get to know the guts of your database and how it hangs together. 2005-8 has the information schema views but they are based on the sys tables.
Never underestimate the power of human stupidity RAH
-
Berlus wrote:
I already let visual studio 2005 generate the code for the adapters
Which means you have no idea how your database is structured. These bloody auto generate things are a disaster and should be taken out and shot. Get into query analyser and look into the system table in the master database. Get to know the guts of your database and how it hangs together. 2005-8 has the information schema views but they are based on the sys tables.
Never underestimate the power of human stupidity RAH
Mycroft Holmes wrote:
Which means you have no idea how your database is structured. These bloody auto generate things are a disaster and should be taken out and shot.
Hurrah, someone that agrees with me. :) Keep the auto generate stuff for the gui parts, learn what your app is actually doing to the database (and how) and most of your problems disappear.
Bob Ashfield Consultants Ltd
-
Mycroft Holmes wrote:
Which means you have no idea how your database is structured. These bloody auto generate things are a disaster and should be taken out and shot.
Hurrah, someone that agrees with me. :) Keep the auto generate stuff for the gui parts, learn what your app is actually doing to the database (and how) and most of your problems disappear.
Bob Ashfield Consultants Ltd
I use a lot of auto generated code, for the stored procs and the class to service the table, mind you I wrote the generator so I know whats under the hood. My greatest worry is that the BOSS is going to demand DB agnostic code - there go all my stored procs.
Never underestimate the power of human stupidity RAH
-
I use a lot of auto generated code, for the stored procs and the class to service the table, mind you I wrote the generator so I know whats under the hood. My greatest worry is that the BOSS is going to demand DB agnostic code - there go all my stored procs.
Never underestimate the power of human stupidity RAH
Mycroft Holmes wrote:
I use a lot of auto generated code, for the stored procs and the class to service the table, mind you I wrote the generator so I know whats under the hood.
Snap. I don't consider that sort of code autogenerated (although I suppose it is really), its the rubbish generated by VS that I object to.
Bob Ashfield Consultants Ltd
-
Hello, I am required to supply q programtic solution to import\export the data and the struture (also foreign keys and views) of a table that resides at the sql server using c#. Is there a easy, auto generated way to do so ? I already let visual studio 2005 generate the code for the adapters of the various tables in order to retrieve\update the data. Thanks, Berlus
Have you looked at DTS in SQL Server 2000? It's for this sort of thing...