July 1, 2011 at 8:10 am
I am migrating MS access Db to SQL 2008 and I am using SSMA to accomplish this task. But I’ve couple of questions.
1. When I run ssma I got 2 error saying that two of the queries could not be converted
(Is that a problem as I see all table are migrated successfully but 2 queries have issues)
2.What would be the best approach to do this in production? I’ll be doing this in Dev environment for now but this step should be repeatable so that it can be implemented in production. Now the issue is the MDB file doesn’t have current data in it and that is fine for dev environment but when we’ll be doing this in production we’ll have to get the current back up of mdb file ..i am worried if there is an issue while converting the
Access db to sql via SSMA on that Production implementation day as we’ll have only couple of hours to complete this task.. Is there anyone who has done similar kind of task? Please help me here … I would like to know the approach I should take for this task
July 1, 2011 at 8:35 am
Duplicate post -
http://www.sqlservercentral.com/Forums/Topic1135045-391-1.aspx
________________________________________________________________________________
Can I ask you a rhetorical question...?
________________________________________________________________________________
July 1, 2011 at 2:39 pm
trevelvis (7/1/2011)
Duplicate post -http://www.sqlservercentral.com/Forums/Topic1135045-391-1.aspx
Bad! :w00t:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply