Friday, December 07, 2012 8:34 PM
I am using Access 2010 as a Gui for SQL Server 2012, and to make things easier I am using SSMA v.5.2.1257. Now with all this info I TRY to migrate from Assess to SQL. All goes well, BUT there are NO files in the folder on the SQL Server. CAN YOU PLEASE help me?
P.S. Hope I am talking to the right Forum...
Saturday, December 08, 2012 9:48 PM
What do you mean with 'there are no files in the folder on the SQL Server'? Are there no '.mdf' and '.ldf' files in the data and log directories? Or do you expect your tables to be stored in files. If the last, I must disappoint you. SQL Server is no toy database with tables stored in seperate files. Try the management studio, open your database, open your tables hive and lo and behold.
I think this forum is for SSMA questions. But this question is not on the SSMA tool, as far as I can see.
Monday, December 10, 2012 9:05 PM
you need to understand the architecture of SQL server. Ms access files are stored in a filder.
but sql server is different. it has an engine called database engine which is connected to .mdf (to store data) and .ldf (to store transactions) for every database.
sql engine writes every transaction to .ldf file before it writes to .mdf file.
after migrating your database to sql server go to SSMS and right click on your database choose properties>> select files>> you will notice where your data and log files are stored..
i recommend to know more about T-SQL before you deal with SQL data...there are number of book online..
if you have any questions you are welcome to post questions in the T_SQL forum.
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Tuesday, December 25, 2012 5:33 AM