locked
Steps to migrate from Access to SQL - Swedish Access with Swedish characters in queries and table names RRS feed

  • Question

  • Hi

    I am a developer of Access databases for craft breweries in Sweden.
    Now its time to start migration to SQL server.

    I have a Swedish version of Access and I have used national characters (like å, ä and ö) in my naming of queries and tables.
    I also have names with the character "space".

    Two questions:

    Will this be a problem or not?

    According to your experiences, what is the main preparations I have do do before starting the migration? 


    Best // Peter Forss Stockholm and Sigtuna GMT +1.00

    Friday, May 13, 2016 4:37 AM

Answers

  • Hi ForssPeterNova,

    Firstly, it is recommended to use SQL Server Migration Assistant for Access for migration process. By default, it will transfer Access text data types (e.g. Long text, Short text, Hyperlink) to SQL Server data type nvarchar() so Swedish characters are supported.  A issue could happen is that after migration, there may be unexpected html tags like<div></div> in nvarchar columns,  which is due to that the source column in Access is long text (or memo) and it’s in rich text format. If you don’t want to keep the format, you can change the text format to plain text and redo the migration process.

    Secondly, by using the Migration Assistant, Access queries are migrated to SQL Server Views, for more information, Please refer to MSDN article (https://msdn.microsoft.com/en-us/library/hh313041(v=sql.110).aspx ).

    Thirdly, here's a list of things you may need consider before migration, please refer to MSDN article (https://msdn.microsoft.com/en-us/library/hh313061(v=sql.110).aspx ).

    If you have any other questions, please let me know.

    Regards,
    Lin


    Monday, May 16, 2016 9:19 AM

All replies

  • Hi ForssPeterNova,

    Firstly, it is recommended to use SQL Server Migration Assistant for Access for migration process. By default, it will transfer Access text data types (e.g. Long text, Short text, Hyperlink) to SQL Server data type nvarchar() so Swedish characters are supported.  A issue could happen is that after migration, there may be unexpected html tags like<div></div> in nvarchar columns,  which is due to that the source column in Access is long text (or memo) and it’s in rich text format. If you don’t want to keep the format, you can change the text format to plain text and redo the migration process.

    Secondly, by using the Migration Assistant, Access queries are migrated to SQL Server Views, for more information, Please refer to MSDN article (https://msdn.microsoft.com/en-us/library/hh313041(v=sql.110).aspx ).

    Thirdly, here's a list of things you may need consider before migration, please refer to MSDN article (https://msdn.microsoft.com/en-us/library/hh313061(v=sql.110).aspx ).

    If you have any other questions, please let me know.

    Regards,
    Lin


    Monday, May 16, 2016 9:19 AM
  • Thanks Lin

    I find your information useful.

    I might come back with more questions.


    Best // Peter Forss Stockholm and Sigtuna GMT &#43;1.00

    Monday, May 16, 2016 10:39 AM