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 |
|
associates
Starting Member
31 Posts |
 Posted - 2006-08-07 : 02:50:59
|
| Hi,I was wondering if anyone might be able to help me here. I'm very new to SQL server and has been asked to convert microsoft access database .MDB to SQL server. In another word, i'd like to migrate access to SQL Server. It's not a huge database. The size of it is roughly 6MB. The reason for migration is simply because our clients don't have microsoft office running on their system. They use SQL Server. This's a new challenge to me as i'm more comfortable with using Access now. I have been searching and studying it thru the online tutorial about what it's and what it does. I have also downloaded and installed the SQL Server 2005 Express edition because it has GUI Interface and it does have the ability to produce reports like Access does. Now my question is how do i start because when i created the database i didn't think of any client/server application? so if i want to run the Access, i just double click it and start using it. how do i migrate it to SQL Server for a testing sake? I really need some guidance here please.Thank you in advance |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-07 : 03:23:57
|
| MS Access has an upgrade guide to convert an Access solution to MS SQL. Run the wizard.Peter LarssonHelsingborg, Sweden |
 |
|
|
associates
Starting Member
31 Posts |
Posted - 2006-08-07 : 20:12:12
|
| Hi Peso,Thank you for your reply.I think you're talking about the upsizing wizard in Access. Correct me if i'm wrong. I have used it and always encountered problem when it comes to login stage. I can't get through it.1. Initially, it asks if i want to create a new database - yes2. It asks "what SQL server would you like to use for this database?" - local3. select "use trusted connection" and also tried to deselect it and type in login and username (both don't help)Result: Connection failed... SQL Server doesnot exist or access deniedI have started the SQL Server Express though. I chose windows authentication because the SQL Server authentication didn't work.Is there anything that i missed out here?Thank you in advance |
|
|
|
andrew15000
Starting Member
2 Posts |
Posted - 2007-07-25 : 10:45:59
|
| Hi,I have been having the same problem, no one seems to have any knowledge on this issue. It is really bad. I even tried a Microsoft forum, and I have had no answers, except for someone saying I have a permissions issue, and when I asked for an expansion on that, I got zip, nothing. Am I ranting, or maybe I am, it has taken me 2 weeks to get nowhere, frustrated like hell with the lack of knowledge out there by even the experts. It looks like the Upsizing Wizard by Microsoft is a complete con,it is a fraud, it simply does not work - Period!Andrew |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-07-26 : 02:50:17
|
| I suspect you may find you have other issues too. You say your client dont have MS Office on their systems and you also mention using reports in Access.I dont have access to a SQL 2005 server so I may be mistaken, however if you have forms and reports in Access currently you may have to recreate them elsewhere e.g. ASP.NET or a Windows forms app. i.e. you may have to recreate the user interface.In our case we have an MS access application that links to SQL server data, all the forms and reports are held in MS Access. Moving to a non MS OFfice environment for us would certainly be a non trivial excercisesteve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
andrew15000
Starting Member
2 Posts |
Posted - 2007-07-26 : 08:32:39
|
| Hi SteveThanks for your reply and what you shared, I actually purchased Office 2007 to help with the process, so I am using the latest upsizing wizard. Also my Access database does not have any forms in it, just tables.I just got a message from one forum, they said install the free version of enterprize import from the version and output to 2005 Express version.So I will give that a try today |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
|
|
migrate Access to SQL 2005 Express