Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2010-01-13 : 11:33:04
|
I'm working on Access 2003 database to SQL Server 2005 conversion.I was thinking to use SQL Server Migration Assistant wizard to do this but I'm not really sure if it's going to work.Could someone please explain a bit in detail how I should get this done(moving data from access to sql server)? |
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2010-01-13 : 11:35:56
|
Forgot to ask one more thing, when should I involve a data modeler? I mean, should I involve one after pusing the data to sql server or before pushing? |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2010-01-13 : 11:42:45
|
HI prodigy2006,You can Use SSMS,an easy way to do this migration.1.Create the Empty database in target server 2.Right click and go to task 3.From the task go to IMPORT data 4.In the window select the source as Microsoft Access specify the file name by browsing through the file5.And select the Destination,I think next you can proceed with the clicking next button.Hope this will help you. |
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2010-01-13 : 12:04:35
|
I tried using the Import\Export wizard, but it wasn't even detecting the tables that are in the access database.Any other ideas? |
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2010-01-13 : 17:05:34
|
Is it better if I create an SSIS package or should I use Migration Assistant wizard? |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2010-01-14 : 01:34:18
|
what is the file extension for your access database.I guess it should be .MDB ..In the IMPORT/EXPORt wizard select directly the file i mean.MDB file extension.I hope this will help.If any error please post it here .. |
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2010-01-14 : 09:26:43
|
What do I give the source as? |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2010-01-14 : 09:44:10
|
Browse for your database i mean <filename>.mdb |
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2010-01-14 : 11:21:42
|
This is how I tried before but was unsuccessful.Anymore ideas please? |
|
|
|
|
|