Results 1 to 5 of 5
  1. #1
    AnkurJain1410 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Bangalore, India
    Posts
    3

    Access 2010 to SQL 2014 using SSMAforAccess.exe - XML schema files

    I am using SSMA to Access for a particular migration project to migrate all possible tables, views, linked tables, etc. I am using the default schema XML files available in C:\Program Files (x86)\Microsoft SQL Server Migration Assistant for Access\Sample Console Scripts and customized ConversionAndDataMigrationSample.xml, VariableValueFileSample.xml, ServersConnectionFileSample.xml files to provide all source, destination and variables to SSMA based on the requirement of my project. I executing SSMAforAccess.exe in cmd by passing the location of these xml files containing source, destination, variables details required to complete the migration. Migration works perfectly however i want to store a particular service account credentials in connection string to link my Access tables with SQL tables, this can be achieved by marking Linked Table property as "True" in Default project settings of SSMA GUI. It does work and stores the service account credentials in connection string when i directly create a project using SSMA GUI however whenever i try to achieve the same using xml files execution method, the connecting string in the linked tables generates without any service account credentials in it and which is an issue as per the requirements of the project. I am using the below node in ConversionAndDataMigration.xml schema XML file to map Linked Table property as "True" in Default project settings in XML.
    Click image for larger version. 

Name:	SSMA GUI - Linked Table Property.png 
Views:	14 
Size:	15.9 KB 
ID:	24484
    <link-table-security mode = "Yes"/>



    Also tried values like True, 1, yes, true, etc.

    I could be wrong here in choosing this node to store required user credentials in connection string. Could you please direct me to correct node or method to store service account credentials in connection string while migrating access data to SQL using CMD & XML files.

    Your prompt response would be really appreciable.

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    Im so out of my element on this question, but have you tried the intrinsic value for true? long shot.

  3. #3
    AnkurJain1410 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Bangalore, India
    Posts
    3
    Quote Originally Posted by Perceptus View Post
    Im so out of my element on this question, but have you tried the intrinsic value for true? long shot.
    Yes, myself and team have tried lot many values/options we can think of to fix this issue but no success.

  4. #4
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    can you verify the settings are being applied?
    does changing other settings work?

  5. #5
    AnkurJain1410 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Bangalore, India
    Posts
    3
    Quote Originally Posted by Perceptus View Post
    can you verify the settings are being applied?
    does changing other settings work?
    Yes, we have changed few other settings while converting data from access to excel and everything works. But for linked tables the XML process to convert access to sql not working. We can create the linked tables but the connection string doesn't reflect the credentials we like to add.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access Database Schema
    By Shilabrow in forum Access
    Replies: 9
    Last Post: 05-06-2014, 10:11 PM
  2. Replies: 3
    Last Post: 01-27-2014, 02:45 PM
  3. Access 2010-runing old files
    By gg80 in forum Access
    Replies: 4
    Last Post: 01-09-2014, 09:57 AM
  4. Replies: 3
    Last Post: 01-31-2013, 01:03 PM
  5. Replies: 1
    Last Post: 09-28-2011, 01:24 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums