|
Home > Archive > SQL server exams > July 2004 > Where it goes to after DTS Import?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Where it goes to after DTS Import?
|
|
| harriskore 2004-07-03, 7:09 pm |
| Dear ladies & Gentlemen:
Just want to try what it looks like, I opened "Engterprise Manager", expanded "Microsoft SQL Server", then default server name. Right click on "Date Transformation Service", "All Tasks", "Import Data", click "Next" on DTS Wizard. Data Source "Biblio.mdb", then "next" on each screen until it comes up "Finishes".
Now, I try to locate this importation. But just cannot find anything.
Curious where it goes after I import Biblio.mdb (using DTS) to SQL?
Thanks for any advice.
Harris Kore | |
|
| I avoid the use of wizards like the plague, but in general the way DTS works is you specify both a DTSSource and DTSDestination. These become objects in the DTS package which you then "data pump" through transformations. Transformations can be simple mappings of source to destination fields or more complex VBScript routines.
For what it sounds like you're trying to do, however, it would be much easier to use the SQL Server upsizing tool. It'll handle converting Access datatypes to SQL Server datatypes for you automatically. Otherwise you'll need to manually create the destiantion table structure first. The upsizing wizard is under the tools -> database utilities menu (in Access 2000 anyway.) | |
| harriskore 2004-07-05, 12:08 pm |
| Dear Crito:
Thanks for your advice.
I followed your instruction, opened Biblio.mdb from Access. Select 'Tool' menu, open 'Upside Wizard', then use default destination 'Microsoft SQL Server', .... then 'Finish' for a new database 'Upsize_database'.
But when I open SQL Enterprise Manager, I still cannot see any new database except the default 'Northwind'.
I even opened up 'Query Analyzer', and same result, cannot see any database from the drop down menu.
Where it goes ??? | |
|
| I haven't used it in years, but if memory serves me the upsizing wizard doesn't create a new database, it just moves the tables into an existing database. Might want to check your connection to SQL Server by attempting to attach a table in Access first. If that doesn't work it's probably a configuration issue. Might also want to check Access' help file and/or Microsoft's site for more detailed instructions... training ain't my thang.  I remember it was fairly straight forward however. GL | |
| harriskore 2004-07-07, 3:04 am |
| Dear Crito:
Would hope I understand your instruction correctly. This is what I did:
1. Open up Biblio.mdb (This is the Access file included with Visuala Baisc 6.0 for training purpose on Publilsher/Title/Authors)
2. From Tool (menu), then 'Database Utilities', then click on 'Upsize Wizard'
3. From the first 'Upsize Wizard' screen, I select 'Create New database', then click 'Next' button.
4. From the second 'Upsize Wizard' screen, I keep default destination folder that is 'Microsoft SQL Server' and also keep default database name 'Upsize_Database'.
5. From the third 'Upsize Wizard' screen, I select 'All Available fields to export to SQL Server'.
6. From the fourth 'Upsize Wizard' screen, I keep all default (Table, index ....)
7. From the fifth 'Upsize Wizard' screen, I keep default 'No application changes'.
8. From the last 'Upsize Wizard' screen, I only can click 'Finish' and it automatically opens up an 'Upsize Wizard Report' that it is sucessfully completed.
Then, I open up SQL 'Enterprise Manager' and tried to find our where is the 'Upsize-Database', but nothing.
I also tried use 'search' to search all my system but still nothing under the name 'Upsize_Database'.
Quite confusion .... | |
|
|
|
|
|