Re: Export database to a txt file.
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 02/13/05
- Next message: database_princess: "Filtered Recordsets"
- Previous message: Stanko Milosev: "Re: Export database to a txt file."
- In reply to: Stanko Milosev: "Re: Export database to a txt file."
- Next in thread: Michael Clifford: "Re: Export database to a txt file."
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 13 Feb 2005 21:47:59 -0000
As Andrew has rightly suggested Backup and Restore may be the best and almost certainly the least complicated way of doing this.
Take a look at SQLLiteSpeed as well for compressing backups.
-- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - SQL Server 2005 Integration Services. www.Konesans.com "Stanko Milosev" <stanko@-no-s-pa-mmilosev.co.yu> wrote in message news:euVXpQhEFHA.3416@TK2MSFTNGP09.phx.gbl... > We need data to be transfered, smallest possible, because connections here > are terrible, so that remote transfer be fastest as possible. > > > Thank you, once again, for your time, > Stanko. > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:#MSG4BhEFHA.936@TK2MSFTNGP12.phx.gbl... >> If you want all the tables and data then why not simply do a backup. You >> can then restore that to another server and you will have everything. >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "Stanko Milosev" <stanko@-no-s-pa-mmilosev.co.yu> wrote in message >> news:%23rAQatfEFHA.2508@TK2MSFTNGP09.phx.gbl... >> > Greetings from Serbia, >> > as subject saids, does anyone had expirience with it? >> > >> > I need to find a way to export a database, with all tables, and > relations >> > if >> > it is possible to a one or more txt files. This is my first task in this >> > new >> > company (http://www.netcomp.co.yu/) and only idea which I have to export >> > table by table to txt file. >> > >> > Thank you in advance, >> > Stanko. >> > >> > >> >> > >
- Next message: database_princess: "Filtered Recordsets"
- Previous message: Stanko Milosev: "Re: Export database to a txt file."
- In reply to: Stanko Milosev: "Re: Export database to a txt file."
- Next in thread: Michael Clifford: "Re: Export database to a txt file."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
