Stack Overflow
Stack Overflow

Questions tagged [sql-server-migration-assi]

SQL Server Migration Assistant is a tool to automate migration from number of various databases (Oracle, Access, Sybase, MySQL) to SQL Server platform.

SQL Server Migration Assistant is a tool to automate migration from number of various databases (Oracle, Access, Sybase, MySQL) to SQL Server platform.

Product home page: https://learn.microsoft.com/en-us/archive/blogs/ssma/

70 questions
0
votes
1 answer

Generation of ROWID column in triggers even when its generation is switched off in SSMA v 6.0

I used SSMA v6.0 for migrating my Oracle database to SQL Server 2014. I turned off the generation of ROWID column and as expected it did not generate any additional ROWID column in any of my tables after conversion, but surprisingly it DID generate…
Sana.91
  • 1,999
  • 4
  • 33
  • 52
0
votes
0 answers

No option for turning off generation of ROW ID Column for SQL Server 2014 in SSMA v5.3

i need to turn off the generation of ROW ID column that SSMA generates automatically in SQL Server 2014. This Option can be turned off in SQL Server 2012 and previous versions but not in SQL Server 2014. Why is this so ? ... Can i turn it off any…
Sana.91
  • 1,999
  • 4
  • 33
  • 52
0
votes
0 answers

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine'

I am trying to migrate my existing Access2007 database to sql server 2008. Installed SSMA for that purpose. Everything goes fine until it starts migrating the data. I get an error Establishing connection with the source database failed. The…
Steve
  • 522
  • 3
  • 12
  • 28
0
votes
1 answer

SSMA for MySQL only loads the first thirteen tables?

I am using SQL Server Migration Assistant for MySQL v5.3.0 and I am able to connect to MySQL and see my database. The problem is that I only see the first thirteen tables in my MySQL database? There are actually over a thousand tables: Any help…
Thomas Fonseca
  • 542
  • 4
  • 12
0
votes
1 answer

After access to sql migration using SSMA only 100 rows are being returned

I migrated an access db to SQL using SSMA. My application still contacts the Access .mdb file and returns the record. before migration : the table which is being used to populate data in the UI has 1000 rows and displays 1000 rows if the application…
Jayaraman
  • 147
  • 1
  • 11
0
votes
1 answer

What kind of database the Sql Server Migration Assistant uses as an internal data repository?

What kind of database the Sql Server Migration Assistant uses as an internal data repository and stores it in the source-metabase.mb file? I guess that this it is one of standard tool that I could use to open and edit some entries (I need to…
Roman Pokrovskij
  • 9,449
  • 21
  • 87
  • 142
0
votes
1 answer

Connect to Oracle using SSMA

Hope you can help. I'm trying to connect to an Oracle database using SSMA for Oracle (v5.2.1259). I have tried connecting to the remote database (Oracle 10g) and to a local database database (Oracle 11g) but neither is working. What I would…
denimknight
  • 301
  • 2
  • 9
  • 22
0
votes
1 answer

Sql Server Migration tool not quite working

I was finally able to get the schema correct on both sides. Im ready to run the final step and.... Data migration started.... Data migration failed... System.Data.OracleClient requires Oracle client software version 8.1.7 se I have done ever…
None
0
votes
1 answer

SSMA AccesToSQLAzure - exception in C# Access Application

I migrated my Access2007 (.accdb) to a SQL Azure Database with SQL Server Migration Assistant and it works great with some issues but thats not the point now. Some time ago i wrote a C# Winforms application which connects to my Access Database and…
user1353816
  • 23
  • 1
  • 4
-1
votes
1 answer

Migration On-premises SQL Server 2008 to Azure vm

How to identify workload ? testing performance issue ? Before migration what i have to check in the VM ? after migration any db setting need to change ?
jega
  • 1
  • 1
1 2 3 4
5