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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 import export sql server 2008 developer edition

Author  Topic 

bghodsi
Starting Member

7 Posts

Posted - 2009-11-25 : 11:32:24
When I use import export feature of sql server 2008 to convert msacess database to sql server database, everything works fine except for the fact that I can not locate the converted files. Can anyone help?

Thanks

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-11-25 : 13:10:39
What type of files you are expecting?
After import it is not longer an access database - it is an sql server database and with that files you can/should do nothing.
Have a right click on your new created sql server database in properties - files you can see the location of mdf and logfile in disk-system.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

bghodsi
Starting Member

7 Posts

Posted - 2009-11-26 : 17:39:15
Right click on newly created database? There is no database with mdf and log file anywhere.
Please be more explicit in responding to this inquiry.

Thank you
Go to Top of Page

bghodsi
Starting Member

7 Posts

Posted - 2009-11-26 : 17:40:51
Can you describe to me fully how you take an access file and convert to to sql server .
Go to Top of Page
   

- Advertisement -