June 5, 2015 at 6:30 am
Hi everyone,
Has anyone had an issue with not seeing the Review Data Type Mapping Screen in SQL Server Import and Export Wizard?
Is there only a certain version where that screen shows up?
I am trying to import data from an MS Access application to SQL Server and all of the connections are good, but some of the data isn't and if I let it migrate using this tool it crashes on the bad data and there is no data that migrates. The Review Data Type Mapping screen will allow me to bypass the records in error and load the rest. however, I can;t do that if I cannot see the screen.
Please help!
Thanks,
Joe
June 5, 2015 at 12:54 pm
has anyone ever come across this? Better still, is there another way to migrate data from MS Access to SQL server where there are options to bypass data that does not match the target datatypes?
Please help!
June 8, 2015 at 10:10 am
Could the reason why I do not see the 'Review Data Type Mapping' screen because I am using SQL Server 2008 R2 Developer edition as opposed to Enterprise Edition?
June 8, 2015 at 10:18 am
jpserra3 (6/8/2015)
Could the reason why I do not see the 'Review Data Type Mapping' screen because I am using SQL Server 2008 R2 Developer edition as opposed to Enterprise Edition?
The Developer's Edition has all the features/functionality of the Enterprise Edition.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 8, 2015 at 10:19 am
ok, then is it a feature that needs to be turned on?
June 10, 2015 at 11:05 am
Have i stated a problem that no-one has seen? does this screen (Review Data Type Mapping screen) show up for everyone else?
June 10, 2015 at 1:03 pm
is this screen only for a certain input? (i.e. flat file)
June 10, 2015 at 1:06 pm
jpserra3 (6/10/2015)
Have i stated a problem that no-one has seen? does this screen (Review Data Type Mapping screen) show up for everyone else?
Well, I never use the wizard, and I don't recall this happening before.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 1:08 pm
have you ever migrated data from MS Access to SQL Server 2008 r2?
June 10, 2015 at 1:18 pm
jpserra3 (6/10/2015)
have you ever migrated data from MS Access to SQL Server 2008 r2?
I haven't.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 10, 2015 at 1:50 pm
my guess is of the almost 100 people who have looked at this post, no-one has.
June 11, 2015 at 7:00 am
i did find out one thing, the Review Data Type Mapping screen in the Import and Export Wizard of SQL Server doesn't show for MS Access to SQL Server, but Does show up for Flat File to SQL Server. I am not sure why it doesn't for MS Access to SQL Server. It would really make life easier if it would. I am still trying to find a way to get all of the records imported (or at best all of the clean records).
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply