Data Export with ADO

Hi All,

I want to develop a small tool to export data from a database (SQL Server and Oracle). I have to export full tables or part of tables depending on an SQL statement.

My first idea is to use ADO. I open a recordset on the table (adCmdTable) and I call the Save method to save the recordset in a file. But, when I open the recordset, it takes a long time ... I suppose that ADO performs a " select * from table " to retreive all the lines ... It's too long for me because some tables have more then 10 millions of lines !!!

Do you known if it's possible to open a table without any "select" (just open and save) ? Do you kown others solutions ? I can develop with DO or ADO.Net.

Thanks in advance for your help.

Fran?ois.

Using adCmdTable causes the client to wait until the table parameters are collected, including a row count.

You should be using ADO.NET (and Visual Studio.NET).

ADO.NET is a disconnected model, so there is no traffic UNTIL you execute your query, returning only the data requested. Any 'slowness' at the start up will be due to the overhead of establishing the connection, and if you judiciously use connection pooling, that may not be much of an issue.

|||Have you looked into SSIS (SQL server integration Service) shipped as part of SQL 2005? You might not need to roll your own tool after all.|||

I try to use the WriteXml method of a DataSet to export my data. I don't want to user a "select * from table" select statement because the number of rows can be very important (more that 10 millions of lines), so I want to set the CommendType if my SqlCommand objet to TableDirect, but I have an error message : "this is not supported by SlqCLient .Net Framework" ! Is there any solution to biend a dataset on a table (without any SQL statement) and call the WriteXml method ?

Thanks.

Fran?ois.

|||SSIS is nice if you use SQL Server. But, unfortunatly, we have some customers with Oracle ... That's why I try to find a "universal" solution.|||No, 'unfortunately' using SQL Server requires the use of the SQL language. (Go figure...)

Data Enabled WebSite

I am looking at developing a data enabled web site. I am quite proficient
with SQL server, VB & ASP. For these reasons I have decided to develop the
site in ASP.NET (learning presently) with an SQL Server backend.
I have been told this is not the way to go and the better alternative is PHP
& MySQL.
I would appreciate any feedback re the pros and cosn of each option and
whether there is truth to this or not.
ThanksIf your quite proficient in that why would you want to change? Being
familiar with a tool(s) goes a long way and can help to reduce costs quite a
bit by being more accurate, confident and faster.
--
Andrew J. Kelly
SQL Server MVP
"Murphy" <murphy@.murphy.com> wrote in message
news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> I am looking at developing a data enabled web site. I am quite proficient
> with SQL server, VB & ASP. For these reasons I have decided to develop the
> site in ASP.NET (learning presently) with an SQL Server backend.
> I have been told this is not the way to go and the better alternative is
PHP
> & MySQL.
> I would appreciate any feedback re the pros and cosn of each option and
> whether there is truth to this or not.
> Thanks
>|||Exactly, my thoughts precisely however if the general opinion was that I was
going down the wrong path then i would be forced to learn new tricks in
order to complete the task correctly.
If there general opinion is that it's mrerly a matter of choice then I'll
stay with what I know.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OoFH5sNoDHA.1884@.TK2MSFTNGP09.phx.gbl...
> If your quite proficient in that why would you want to change? Being
> familiar with a tool(s) goes a long way and can help to reduce costs quite
a
> bit by being more accurate, confident and faster.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Murphy" <murphy@.murphy.com> wrote in message
> news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > I am looking at developing a data enabled web site. I am quite
proficient
> > with SQL server, VB & ASP. For these reasons I have decided to develop
the
> > site in ASP.NET (learning presently) with an SQL Server backend.
> >
> > I have been told this is not the way to go and the better alternative is
> PHP
> > & MySQL.
> >
> > I would appreciate any feedback re the pros and cosn of each option and
> > whether there is truth to this or not.
> >
> > Thanks
> >
> >
>|||Murphy,
Stick with your initial tools. You are building a solution that assumes IIS
and SQL Server, but these are very well accepted technology solutions.
bill burrows
"Murphy" <murphy@.murphy.com> wrote in message
news:uCcCN1NoDHA.2216@.TK2MSFTNGP12.phx.gbl...
> Exactly, my thoughts precisely however if the general opinion was that I
was
> going down the wrong path then i would be forced to learn new tricks in
> order to complete the task correctly.
> If there general opinion is that it's mrerly a matter of choice then I'll
> stay with what I know.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OoFH5sNoDHA.1884@.TK2MSFTNGP09.phx.gbl...
> > If your quite proficient in that why would you want to change? Being
> > familiar with a tool(s) goes a long way and can help to reduce costs
quite
> a
> > bit by being more accurate, confident and faster.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Murphy" <murphy@.murphy.com> wrote in message
> > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > I am looking at developing a data enabled web site. I am quite
> proficient
> > > with SQL server, VB & ASP. For these reasons I have decided to develop
> the
> > > site in ASP.NET (learning presently) with an SQL Server backend.
> > >
> > > I have been told this is not the way to go and the better alternative
is
> > PHP
> > > & MySQL.
> > >
> > > I would appreciate any feedback re the pros and cosn of each option
and
> > > whether there is truth to this or not.
> > >
> > > Thanks
> > >
> > >
> >
> >
>|||Get a decent database structure and access.
You already know sql server so will be able to cunstruct
that easily and a decent stored procedure interface.
Without this there is not hope of building a reliable
efficient system. You can spend the time you would have
spent learning a new database on testing and refining this
one.
Adain you should find it easier to learn and be effective
in (make less serious mistakes) in asp.net than in php if
you already know asp well.
If you go for php and mysql you will just be another
beginner trying to hack together a web site.|||Ignore the advice!
I work day in day out with PHP/MySQL and although they are open source,
reliable and easy to work with, I am now opting to go down the .NET route.
SQL Server is a more powerful database and .NET is a more powerful platform
to code on.
"Murphy" <murphy@.murphy.com> wrote in message
news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> I am looking at developing a data enabled web site. I am quite proficient
> with SQL server, VB & ASP. For these reasons I have decided to develop the
> site in ASP.NET (learning presently) with an SQL Server backend.
> I have been told this is not the way to go and the better alternative is
PHP
> & MySQL.
> I would appreciate any feedback re the pros and cosn of each option and
> whether there is truth to this or not.
> Thanks
>|||Not sure its a good idea to ignore the advice... I'm all .NET myself, but
MySQL and PHP certainly is a good "cost free" alternative. Now that's said;
go with .NET and SQL Server!
--
Carsten Thomsen
Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> Ignore the advice!
> I work day in day out with PHP/MySQL and although they are open source,
> reliable and easy to work with, I am now opting to go down the .NET route.
> SQL Server is a more powerful database and .NET is a more powerful
platform
> to code on.
> "Murphy" <murphy@.murphy.com> wrote in message
> news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > I am looking at developing a data enabled web site. I am quite
proficient
> > with SQL server, VB & ASP. For these reasons I have decided to develop
the
> > site in ASP.NET (learning presently) with an SQL Server backend.
> >
> > I have been told this is not the way to go and the better alternative is
> PHP
> > & MySQL.
> >
> > I would appreciate any feedback re the pros and cosn of each option and
> > whether there is truth to this or not.
> >
> > Thanks
> >
> >
>|||As I will be hosting the site with a hosting company who provide the SQL db
etc cost is not an issue to me.
"CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> Not sure its a good idea to ignore the advice... I'm all .NET myself, but
> MySQL and PHP certainly is a good "cost free" alternative. Now that's
said;
> go with .NET and SQL Server!
> --
> Carsten Thomsen
> Enterprise Development with VS .NET, UML, and MSF
> http://www.apress.com/book/bookDisplay.html?bID=105
> "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > Ignore the advice!
> >
> > I work day in day out with PHP/MySQL and although they are open source,
> > reliable and easy to work with, I am now opting to go down the .NET
route.
> >
> > SQL Server is a more powerful database and .NET is a more powerful
> platform
> > to code on.
> >
> > "Murphy" <murphy@.murphy.com> wrote in message
> > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > I am looking at developing a data enabled web site. I am quite
> proficient
> > > with SQL server, VB & ASP. For these reasons I have decided to develop
> the
> > > site in ASP.NET (learning presently) with an SQL Server backend.
> > >
> > > I have been told this is not the way to go and the better alternative
is
> > PHP
> > > & MySQL.
> > >
> > > I would appreciate any feedback re the pros and cosn of each option
and
> > > whether there is truth to this or not.
> > >
> > > Thanks
> > >
> > >
> >
> >
>|||If it's for serious use, go .NET/ASP etc.
If it's for a hobby site (say a VA, if you're afollower of my hobby, FS!)
then MySQl, and PHP are good. Although I still use ASP and SQL.
Angus
"Murphy" <murphy@.murphy.com> wrote in message
news:#KHGm4coDHA.2268@.TK2MSFTNGP12.phx.gbl...
> As I will be hosting the site with a hosting company who provide the SQL
db
> etc cost is not an issue to me.
> "CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
> news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > Not sure its a good idea to ignore the advice... I'm all .NET myself,
but
> > MySQL and PHP certainly is a good "cost free" alternative. Now that's
> said;
> > go with .NET and SQL Server!
> >
> > --
> > Carsten Thomsen
> > Enterprise Development with VS .NET, UML, and MSF
> > http://www.apress.com/book/bookDisplay.html?bID=105
> > "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> > news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > > Ignore the advice!
> > >
> > > I work day in day out with PHP/MySQL and although they are open
source,
> > > reliable and easy to work with, I am now opting to go down the .NET
> route.
> > >
> > > SQL Server is a more powerful database and .NET is a more powerful
> > platform
> > > to code on.
> > >
> > > "Murphy" <murphy@.murphy.com> wrote in message
> > > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > > I am looking at developing a data enabled web site. I am quite
> > proficient
> > > > with SQL server, VB & ASP. For these reasons I have decided to
develop
> > the
> > > > site in ASP.NET (learning presently) with an SQL Server backend.
> > > >
> > > > I have been told this is not the way to go and the better
alternative
> is
> > > PHP
> > > > & MySQL.
> > > >
> > > > I would appreciate any feedback re the pros and cosn of each option
> and
> > > > whether there is truth to this or not.
> > > >
> > > > Thanks
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hi
ASP.NET and SQL Server is the way forward.
Good place to get ASP.NET and SQL Server hosting web space is:
http://www.dotnet-webhosting.com/sql-server-hosting/default.aspx
£22/Month (included web space, SQL Server DB and free domain)
Regards
G,
"Angus Lepper" <CEO@.AngusEnterprises.cjb.net> wrote in message news:<OH9CvnCwDHA.1272@.TK2MSFTNGP12.phx.gbl>...
> If it's for serious use, go .NET/ASP etc.
> If it's for a hobby site (say a VA, if you're afollower of my hobby, FS!)
> then MySQl, and PHP are good. Although I still use ASP and SQL.
> Angus
> "Murphy" <murphy@.murphy.com> wrote in message
> news:#KHGm4coDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > As I will be hosting the site with a hosting company who provide the SQL
> db
> > etc cost is not an issue to me.
> >
> > "CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
> > news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > > Not sure its a good idea to ignore the advice... I'm all .NET myself,
> but
> > > MySQL and PHP certainly is a good "cost free" alternative. Now that's
> said;
> > > go with .NET and SQL Server!
> > >
> > > --
> > > Carsten Thomsen
> > > Enterprise Development with VS .NET, UML, and MSF
> > > http://www.apress.com/book/bookDisplay.html?bID=105
> > > "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> > > news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > > > Ignore the advice!
> > > >
> > > > I work day in day out with PHP/MySQL and although they are open
> source,
> > > > reliable and easy to work with, I am now opting to go down the .NET
> route.
> > > >
> > > > SQL Server is a more powerful database and .NET is a more powerful
> platform
> > > > to code on.
> > > >
> > > > "Murphy" <murphy@.murphy.com> wrote in message
> > > > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > > > I am looking at developing a data enabled web site. I am quite
> proficient
> > > > > with SQL server, VB & ASP. For these reasons I have decided to
> develop
> the
> > > > > site in ASP.NET (learning presently) with an SQL Server backend.
> > > > >
> > > > > I have been told this is not the way to go and the better
> alternative
> is
> PHP
> > > > > & MySQL.
> > > > >
> > > > > I would appreciate any feedback re the pros and cosn of each option
> and
> > > > > whether there is truth to this or not.
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >|||Hi
We offer a very good and reliable service.
http://www.nt-webspace.com
Only £6 / Month and as a special offer we are giving away free domain
till 31st Dec 2003.
Here are the plan details
==========================NO SETUP FEES!
30 day Money Back Guarantee
Windows 2003 ® / IIS ® 6.0 Servers!
24 hour - 7 day a week support!
Unlimited web page updates!
Personal cgi-bin directory
200 MB Disk Space! (Special Offer now 400 MB !! )
Pop3 E-mail boxes with unlimited aliases and auto-responders!
2 GB / Month Bandwidth Transfer!
Microsoft Active Server ?
FTP access for updating web site
Microsoft Access ®/ FoxPro ® Database Support!
Microsoft MS SQL Server 7.0 (£27/mo. additional
Regards
NT-Webspace.com
"Angus Lepper" <CEO@.AngusEnterprises.cjb.net> wrote in message news:<OH9CvnCwDHA.1272@.TK2MSFTNGP12.phx.gbl>...
> If it's for serious use, go .NET/ASP etc.
> If it's for a hobby site (say a VA, if you're afollower of my hobby, FS!)
> then MySQl, and PHP are good. Although I still use ASP and SQL.
> Angus
> "Murphy" <murphy@.murphy.com> wrote in message
> news:#KHGm4coDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > As I will be hosting the site with a hosting company who provide the SQL
> db
> > etc cost is not an issue to me.
> >
> > "CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
> > news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > > Not sure its a good idea to ignore the advice... I'm all .NET myself,
> but
> > > MySQL and PHP certainly is a good "cost free" alternative. Now that's
> said;
> > > go with .NET and SQL Server!
> > >
> > > --
> > > Carsten Thomsen
> > > Enterprise Development with VS .NET, UML, and MSF
> > > http://www.apress.com/book/bookDisplay.html?bID=105
> > > "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> > > news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > > > Ignore the advice!
> > > >
> > > > I work day in day out with PHP/MySQL and although they are open
> source,
> > > > reliable and easy to work with, I am now opting to go down the .NET
> route.
> > > >
> > > > SQL Server is a more powerful database and .NET is a more powerful
> platform
> > > > to code on.
> > > >
> > > > "Murphy" <murphy@.murphy.com> wrote in message
> > > > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > > > I am looking at developing a data enabled web site. I am quite
> proficient
> > > > > with SQL server, VB & ASP. For these reasons I have decided to
> develop
> the
> > > > > site in ASP.NET (learning presently) with an SQL Server backend.
> > > > >
> > > > > I have been told this is not the way to go and the better
> alternative
> is
> PHP
> > > > > & MySQL.
> > > > >
> > > > > I would appreciate any feedback re the pros and cosn of each option
> and
> > > > > whether there is truth to this or not.
> > > > >
> > > > > Thanks
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >|||www.oneandone.co.uk are rather good.
Angus
"NT-Webspace.com" <gbaryah@.hotmail.com> wrote in message
news:792f1e6b.0312120107.7c2f9b03@.posting.google.com...
> Hi
> We offer a very good and reliable service.
> http://www.nt-webspace.com
> Only £6 / Month and as a special offer we are giving away free domain
> till 31st Dec 2003.
> Here are the plan details
> ==========================> NO SETUP FEES!
> 30 day Money Back Guarantee
> Windows 2003 ® / IIS ® 6.0 Servers!
> 24 hour - 7 day a week support!
> Unlimited web page updates!
> Personal cgi-bin directory
> 200 MB Disk Space! (Special Offer now 400 MB !! )
> Pop3 E-mail boxes with unlimited aliases and auto-responders!
> 2 GB / Month Bandwidth Transfer!
> Microsoft Active Server T
> FTP access for updating web site
> Microsoft Access ®/ FoxPro ® Database Support!
> Microsoft MS SQL Server 7.0 (£27/mo. additional
> Regards
> NT-Webspace.com
>
> "Angus Lepper" <CEO@.AngusEnterprises.cjb.net> wrote in message
news:<OH9CvnCwDHA.1272@.TK2MSFTNGP12.phx.gbl>...
> > If it's for serious use, go .NET/ASP etc.
> >
> > If it's for a hobby site (say a VA, if you're afollower of my hobby,
FS!)
> > then MySQl, and PHP are good. Although I still use ASP and SQL.
> >
> > Angus
> > "Murphy" <murphy@.murphy.com> wrote in message
> > news:#KHGm4coDHA.2268@.TK2MSFTNGP12.phx.gbl...
> > > As I will be hosting the site with a hosting company who provide the
SQL
> > db
> > > etc cost is not an issue to me.
> > >
> > > "CT" <carstent@.spammersgoawaydotnetservices.biz> wrote in message
> > > news:%23njCwicoDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > > > Not sure its a good idea to ignore the advice... I'm all .NET
myself,
> > but
> > > > MySQL and PHP certainly is a good "cost free" alternative. Now
that's
> > said;
> > > > go with .NET and SQL Server!
> > > >
> > > > --
> > > > Carsten Thomsen
> > > > Enterprise Development with VS .NET, UML, and MSF
> > > > http://www.apress.com/book/bookDisplay.html?bID=105
> > > > "Andrew Banks" <banksy@.blablablueyonder.co.uk> wrote in message
> > > > news:TD7pb.3738$Yl6.26235112@.news-text.cableinet.net...
> > > > > Ignore the advice!
> > > > >
> > > > > I work day in day out with PHP/MySQL and although they are open
> > source,
> > > > > reliable and easy to work with, I am now opting to go down the
.NET
> > route.
> > > > >
> > > > > SQL Server is a more powerful database and .NET is a more powerful
> > platform
> > > > > to code on.
> > > > >
> > > > > "Murphy" <murphy@.murphy.com> wrote in message
> > > > > news:e9WP3fNoDHA.1020@.TK2MSFTNGP09.phx.gbl...
> > > > > > I am looking at developing a data enabled web site. I am quite
> > proficient
> > > > > > with SQL server, VB & ASP. For these reasons I have decided to
> > develop
> > the
> > > > > > site in ASP.NET (learning presently) with an SQL Server backend.
> > > > > >
> > > > > > I have been told this is not the way to go and the better
> > alternative
> > is
> > PHP
> > > > > > & MySQL.
> > > > > >
> > > > > > I would appreciate any feedback re the pros and cosn of each
option
> > and
> > > > > > whether there is truth to this or not.
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >