SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,201 questions
6 answers
ORA-12541: TNS:no listener". (.Net SqlClient Data Provider)
Hello, I am having issue with connecting oracle from Sql Server using Linked Server. I have installed Oracle client and Sql Server on both the same server. I have tested TNSPING ORCL coming fine Blockquote C:\Windows\system32>TNSPING…
asked 2020-10-02T18:58:38.027+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pdsqsql
411
Reputation points
commented 2020-10-15T00:06:45.73+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 65%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Alexander Ivanov
491
Reputation points
3 answers
SSMA (SQL Server Migration Assistant) for MariaDB
I have on-premise MariaDB. I am Planning to migrate it to Azure SQL Database. Can i use SSMA (SQL Server Migration Assistant) for Migration??? Does SSMA supports MariaDB as source ??
asked 2020-07-09T11:54:32.753+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 85%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Swapnil Solanki
1
Reputation point
answered 2020-10-14T23:43:46.333+00:00
Alexander Ivanov
491
Reputation points
1 answer
Using SSMA for oracle with user having READ ONLY permission
Hi, https://support.microsoft.com/en-in/help/2020711/you-may-get-permission-related-error-messages-when-using-ssma-for-orac With the reference to above link, we do understand the SSMA needs some additional permissions. Its mentioned as To obtain…
asked 2020-07-20T10:49:50.597+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 71%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Madhavi Hardas
1
Reputation point
answered 2020-10-14T23:39:01.08+00:00
Alexander Ivanov
491
Reputation points
3 answers
One of the answers was accepted by the question author.
SSMA challenge with Oracle 0000-00-00 zero date fields
I am using the SSMA migration tool to migrate a large Oracle db to SQL Server 2016. In many of my Oracle date fields I have zero date values 0000-00-00 and records with these date values are not migrating over. I get a Arithmetic operation resulted in an…
asked 2020-09-22T22:36:08.823+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Becky Kent-Dobias
21
Reputation points
answered 2020-10-14T23:07:05.29+00:00
Alexander Ivanov
491
Reputation points
10 answers
One of the answers was accepted by the question author.
SSMA for Access - How can I figure out exactly what table and column or index these warning messages pertain to?
SSMA for Access - How can I figure out exactly what table and column or index these warning messages pertain to? A2SS0030 Identifier name might cause problems A2SS0030: Foreign key '{5A15D9A6-64CE-44B3-AD29-21EAF86F0328}' has a name that might cause…
asked 2020-09-11T09:48:48.66+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 31%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
Bob Alston
121
Reputation points
answered 2020-10-08T21:48:23.697+00:00
Alexander Ivanov
491
Reputation points
1 answer
One of the answers was accepted by the question author.
Connectivity to source DB2 database via SSMA for DB2
I have source database DB2 in IBM Bluemix platform, that need to be migrated on Azure SQL DB using SSMA for DB2. I am trying to make connectivity from SSMA to source DB2 database but not able to do so. I have a very basic question, does SSMA for DB2…
asked 2020-10-04T21:08:07.683+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 0%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
jyoti tiwari
21
Reputation points
commented 2020-10-08T01:32:41.427+00:00
CathyJi-MSFT
21,116
Reputation points Microsoft Vendor
1 answer
Getting error while trying to migrate data to Azure SQL Database from Oracle using the "SSMA for Oracle" tool
I am using the "SSMA for Oracle" tool to migrate Oracle databases to Azure SQL Databases. I am able to migrate the schemas. But I am getting the below error while migrating the data: Error occurred while inserting table information into the…
asked 2020-04-16T03:29:24.827+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 87%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Navneet
1
Reputation point
commented 2020-04-16T23:41:09.663+00:00
Ronen Ariely
15,101
Reputation points