November 29, 2011 at 8:11 am
Hi,
I'm trying to do an export of a database on SQL Server 2000 using DTS Import/Export Wizard. I can't seem to find how the destination of it all works. I have many options such as Driver da Microsoft para arquivos texto (*.txt; *.csv), Driver do Microsoft Access(*.mdb), Driver do Microsoft dBase, Driver do Microsoft Excel, Driver do Microsoft Paradox, Microsft Access-Treiber, Microsoft ODBC Driver for SQL Server, Micorosft OLE DB Provider for SQL Server, Text File, etc...
I've tried to input 'Microsoft OLE DB Provider for SQL Server' for both 'Data Source' and 'Destination', but i don't know how to get the information saved. I've also tried text and it doesn't seem to work.
I need to get the export on a usb drive and import it into another SQL Server 2000. Please let me know if any other info is needed.
Any help is appreciated. Thank you.
November 29, 2011 at 8:20 am
Those drivers are for copying the database from one server to another directly. If you need to save it to USB in between, they won't work.
Your best bet is to do a backup of the database, copy the backup to the USB drive, and then restore it on the other server from that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 29, 2011 at 8:36 am
Thank you for clarifying the info.
Once I've done the backup, save it on a usb, what would be the Data Source when i import the database? I saved it in a folder in C: drive. I can't seem to find the Data Source and/or it is not able to read it when i choose an option.
November 29, 2011 at 8:39 am
meaninglessmilestones (11/29/2011)
Thank you for clarifying the info.Once I've done the backup, save it on a usb, what would be the Data Source when i import the database? I saved it in a folder in C: drive. I can't seem to find the Data Source and/or it is not able to read it when i choose an option.
Are you still in DTS window? Please come out of it. Backup / Restore are different set of operations. I don't understand what exactly you mean by 'Data Source'.
November 29, 2011 at 8:43 am
I've done the backup using the DTS. I'm on a different SQL Server 2000 trying to import the data i've just exported.
Got it. Tried to restore instead of import.
Thank you all for you help.
November 29, 2011 at 9:02 am
I think you're mixing apples and oranges terms. A database backup is performed either in Enterprise Manager by selecting All Tasks -> Backup Database or by using a BACKUP DATABASE statement in Query Analyzer. It produces a backup file that can be moved around in Windows Explorer and can be restored on another server by selecting All Tasks -> Restore Database or by using a RESTORE DATABASE statement. DTS isn't involved at all.
If you want to use DTS, can you set the destination to the destination to the other SQL 2000 server rather than using a usb drive? If not, export to a text file on the usb drive and import on the new server using the text file as the source. Note: if the matching tables don't already exist in the destination datbase, you'll need to create them.
I see you've figured it out. Good day.
Greg
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply