transfer data from one db to another

  • Thread starter Thread starter Brian Scott
  • Start date Start date
B

Brian Scott

Mark,

What is DTS and is there any good examples of it online? I'm in a similiar
situation where I need to migrate customers on an old version of our
software from Access to MSDE / SQL Server. Would this also be appropriate
for DTS?

Thanks.
 
What would you use to, on a regular basis, transfer potentially large sets of
data from one db to another from a c# or vb.net app? The source database(s)
could be msde/sql6.5/sql2000 or sybase ase and the destination db is going to
be an embedded firebird db.
Currently I load up a dataset/datagrid from the source db, generate a new
table in the firebird db, based on the scheme of the dataset, then step thru
the dataset record by record and generate then execute an insert stmt to the
destination db for that record
Is there a faster way to move this data out of the dataset/datagrid into a
new table?

Any thoughts or creative slander are appreciated
g
 
DTS - no question about it.

mike, thanks for the quick reply. i would love to use dts, but in some
senerios i cant as the source data lives in a sybase db. in other senerios
the source data lives in msde. other senerios part of the source data lives
in sybase and antoher in sql 2000. i was under the impression that dts was
only available from sql 2000+. so far the only common ground is ado.net.
i'm having to avoid linked servers for the same reason.
i'm looking more for a single solution that could be used with any/all
combinations of the above databases.
 
mike,
Click to expand...

It's Mark... :-)
i was under the impression that dts was only available from sql 2000+.
Click to expand...

That's not the case at all...

From BOL:
"DTS can import data from a text file or any OLE DB data source (for
example, a Microsoft Access 2000 database) into SQL Server. Alternatively,
data can be exported from SQL Server to any OLE DB data destination (for
example, a Microsoft Excel 2000 spreadsheet). DTS also allows high-speed
data loading from text files into SQL Server tables."
 
Mark,
It's Mark... :-)
Click to expand...
ah, darnit - wellthen you can call me Al.
ah, yes - i see that its available for msde as well. mmm... <scratches
head> maybe i need to reconsider the embedded firebird database in favor of
msde.
but I still like to hassle free, low config of the embedded db though,...

Any other options to provide support for the sybase only senerios without
changing my engine? I'm really just looking for some kind of bulk load
solution for firebird, hoping someone would say "what! you're processing each
row in the dataset and building an insert stmt for each one? - nono do " &
theirSolutionhere
i combining each of the insert stmts into one larger ; delinated stmt but it
didnt seem much faster.

also (while im looking for samples on creating dts packages) the querys that
i'm processing, they are adhoc built from a client driven gui query builder
(looks lilke the visual view builder in ent manager) Are dts packages
something that i can creare & maniplute at runtime from c#/ vb.net?
 
Mark Rae said:
Actually, pretty much anything with an OleDb provider...
Click to expand...

no, i meant to host it. unless you mean that can use dts without any type
of ms db. wouldnt i need at least msde to run it?, for example if i have a
sybase engine as a source db and a firebird db for a destination. i wasnt
under the impression that dts was a standalone option, doesnt it need
installed into a microsoft engine of the sql variety?
 
Back
Top