November 24, 2005 at 8:50 am
How do I import data to SQLserver 2005 Express from SQL server 2000 or access or excel or Text file ?
November 28, 2005 at 9:46 am
Fastest way to import data from SQL Server 2000 to 2k5 is a very generic question.
Are you wondering about the best way performance wise or development time?
Performance wise would very certainly be using BCP or BULK INSERT.
1. Script out the schema
2. Run the CREATE TABLE scripts on 2k5
3. BCP out your data.
4. If the data goes over the wire, compress it somehow
5. Transfer the data to your destination (by the wire or DHL/FedEx for larger amounts)
6. BULK INSERT your data.
7. Run the remaining scripts, on your 2k5 machine, for creating your constraints, indexes and so on and so forth.
Happy hunting.
Hanslindgren
November 30, 2005 at 2:55 am
I want to find the same way for importing data as is in MSSQL2000, right click Tables, All tasks, Import data and next wizard. How is this obtained in MSSQWL2005 Express?
November 30, 2005 at 3:02 am
That requires DTS. The Wizard in SQL Server 2000 you are talking about is part of DTS. DTS (Or SQL Server Intergration Services, SSIS, as it is now called) is not included in the Express versions of SQL Server 2005.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply