SQL Server Migration announcement
-
Link
Need help with migration to SQL Server? Have any questions related to SQL Server Migration Assistant (SSMA) products for Oracle/Sybase/MySQL/Access? Feel free to discuss any SQL Server migration related topics or post any questions related to SSMA.
-
3 VotesPlease Indicate "Mark as Answer" if a Post has Answered the Question
While reading a reply to your question, you will notice a button with an icon that says "Mark as Answer." Please select this button when a reply answers your question. ...Sticky | 1 Replies | 33219 Views | Created by edhickey - Wednesday, April 28, 2010 11:16 PM | Last reply by Carlos Augusto- - Thursday, October 13, 2011 4:34 PM
-
0 Votes
powershell to drop functions
HI I have requirement to drop the assembly functions and recreate it $selfunc = invoke-sqlcmd -server $Instance -Database $db.Name -Query "SELECT ...Proposed | 2 Replies | 147 Views | Created by supersent - Thursday, October 17, 2019 1:44 PM | Last reply by Olaf Helper - Thursday, October 17, 2019 2:16 PM -
1 Votes
How to MySQL to SQL Server Migration (MSSQL 2008)
I want to migration from mysql to MSSQL2008 However, the SSMA provided now does not support MSSQL2008. Previously provided download ...Proposed | 3 Replies | 395 Views | Created by WooSeony - Tuesday, September 24, 2019 8:44 AM | Last reply by ShanayaS - Thursday, October 17, 2019 5:51 AM -
0 Votes
SSMA console - converting sequences.
Hi folks. I'm trying to add to my SSMA XML console script some sequences. Didn't find anything specific about sequences neither online nor in the sample ...Unanswered | 3 Replies | 841 Views | Created by Leandro_Martins_de_Lima - Thursday, July 4, 2019 8:34 PM | Last reply by Leandro_Martins_de_Lima - Wednesday, October 16, 2019 8:48 PM -
0 Votes
SQL Server Migration Assistant for Oracle - Problems converting UUID RAW(16) to uniqueidentifier
Hi I am trying to migrate a UUID field from Oracle type RAW(16) to SQL Server 2016 type uniqueidentifier. Creating the ...Unanswered | 3 Replies | 217 Views | Created by Clemaram - Monday, October 14, 2019 11:51 AM | Last reply by Dedmon Dai - Tuesday, October 15, 2019 8:09 AM -
0 Votes
OS upgrade involved SQL server
Hi, We have a active passive SQL server using WFCS. Because hardware team will upgrade the server hardware and Windows OS. All software will be ...Unanswered | 5 Replies | 480 Views | Created by Ah_Ming - Monday, October 7, 2019 12:03 AM | Last reply by Shanky_621 - Thursday, October 10, 2019 7:17 AM -
0 Votes
SQL Server Migration Assistant for Access: a newer SNAC Provider is required for Link operations
Hi, I have successfully migrated an Access database to Azure SQL. However when I try to link the migrated tables in Access I get an error: A ...Unanswered | 7 Replies | 860 Views | Created by KjetilJansen - Sunday, September 22, 2019 11:33 AM | Last reply by KjetilJansen - Tuesday, October 8, 2019 1:22 PM -
0 Votes
ORA-01017 using OracleClient provider
Greetings, folks. Here I am againg, still battling my way with SSMA. We have a solution almost finished for a inhouse ETL using SSMA, but now we're facing ...Answered | 6 Replies | 533 Views | Created by Leandro_Martins_de_Lima - Friday, September 20, 2019 4:18 PM | Last reply by Alexander-Ivanov - Tuesday, October 8, 2019 5:34 AM -
0 Votes
$impl procedures which are migrated from Oracle Functions
Hi ALL, Getting the following error while converting from Oracle 11.2 to Azure SQL Database through SSMA 8.4 for a Oracle function. Warnings: O2SS0452: ...Unanswered | 6 Replies | 440 Views | Created by Poonam Bangalore - Friday, September 27, 2019 6:39 PM | Last reply by Amelia Gu - Monday, September 30, 2019 10:11 AM -
1 Votes
Querying system tables EXTENDED_PROPERTIES much slower on SQL Server 2016 than SQL Server 2008
17000 rows TABLE_NAME |COLUMN_NAME |ColDescr |ValueName ...Unanswered | 4 Replies | 370 Views | Created by Bas de Reuver - Friday, September 27, 2019 7:50 AM | Last reply by Dedmon Dai - Monday, September 30, 2019 6:52 AM -
0 Votes
Microsoft Data Migration Assistant tool
Hi All, I am using Microsoft Data Migration Assistance tool and i am looking for an option to disable automated updates of latest version. I couldn't ...Proposed | 4 Replies | 346 Views | Created by rajaniora - Thursday, September 26, 2019 6:50 AM | Last reply by Cathy Ji - Friday, September 27, 2019 6:12 AM -
0 Votes
OS upgrade on SQL Mirrored Instances
Hello, We have a principal, a mirror, and a witness servers running on windows 2008 r2. Some of the databases on principal are mirrored and not ...Unanswered | 1 Replies | 308 Views | Created by Xchromosome - Thursday, September 26, 2019 1:29 PM | Last reply by Amelia Gu - Friday, September 27, 2019 5:45 AM -
0 Votes
RDS SQL Server on AWS - migration of ASP.NET website
We are migrating our on-premise .NET website "application that runs in SQL Server" to AWS. I am looking for directions on below features that are not supported by AWS RDS SQL ...Proposed | 1 Replies | 298 Views | Created by OneBlueBird - Wednesday, September 25, 2019 11:59 AM | Last reply by Cathy Ji - Thursday, September 26, 2019 2:47 AM -
0 Votes
Error while converting packages from Oracle to SQL Server Azure
Hello Everyone. I am migrating from Oracle 11 to SQL Server Azure using SSMA v7.11.0 and while migrating package XXXX getting the below ...Proposed | 4 Replies | 451 Views | Created by Poonam Bangalore - Monday, September 16, 2019 2:06 PM | Last reply by Alexander-Ivanov - Monday, September 23, 2019 5:14 PM -
0 Votes
SSMA shows total rows is 0 (actually 20M+ rows)
Dear all I have a question about SSMA, just like the below picture SSMA shows that total rows of the 3rd table is 0, but it actually has 22,292,697 ...Proposed | 4 Replies | 460 Views | Created by GarfieldH - Monday, September 16, 2019 7:39 AM | Last reply by Alexander-Ivanov - Monday, September 23, 2019 5:11 PM -
1 Votes
Failure to connect to MySQL server from SQL Server Migration Assistant
I have SQL Server 2017 Developer installed. I want to use the SQL Server Migration Assistant for MySQL to migrate a MySQL database into SQL Server. But I can't get the migration assistant to ...Answered | 2 Replies | 325 Views | Created by Timothyjb - Monday, September 23, 2019 12:19 PM | Last reply by Timothyjb - Monday, September 23, 2019 1:33 PM -
0 Votes
SSMA - Data Migration of a table from Oracle to SQL Server yields "Errors: Arithmetic operation resulted in an overflow."
desc PMIS.EMP_ACC_HISTORY Name Null? ...Answered | 7 Replies | 803 Views | Created by RJ Timtiman - Wednesday, July 3, 2019 9:39 AM | Last reply by Pardha Saradhy - Friday, September 20, 2019 12:16 PM -
0 Votes
SQLserver 2008 upgrade to SQLserver 2016
Dear Microsoft, We have a server window 2008 installed SQLserver 2008. We would like to migrate the data to new built server window 2016 with SQL Server 2016, Is that possible ...Proposed | 4 Replies | 449 Views | Created by Carlsonshi - Monday, September 16, 2019 8:37 AM | Last reply by Cathy Ji - Friday, September 20, 2019 9:51 AM -
0 Votes
How to troubleshoot database restoring error?
Here's my sql. Any help is much appreciated. USE [master] RESTORE DATABASE [ContinuingDB] FROM DISK = ...Proposed | 4 Replies | 424 Views | Created by Charlie2 - Wednesday, September 18, 2019 12:16 PM | Last reply by Amelia Gu - Friday, September 20, 2019 7:06 AM -
0 Votes
SSMA - Connect to Oracle yields invalid username/password error, even though correct username/password has been entered
Hi all, I am getting the ORA-01017 invalid username/password error when trying to connect to Oracle in SQL Server Migration Assistant, even though the credentials I entered ...Answered | 6 Replies | 1117 Views | Created by RJ Timtiman - Thursday, June 20, 2019 8:00 AM | Last reply by RJ Timtiman - Thursday, September 19, 2019 9:09 AM -
0 Votes
Error while running SQL Database migration assistant
Hello Expert, While running the SQL Database migration assistant against a database I run into this error which halts the analysis process...please any clue ...Proposed | 2 Replies | 379 Views | Created by ghostme - Tuesday, September 17, 2019 2:11 PM | Last reply by Dedmon Dai - Wednesday, September 18, 2019 7:43 AM - Items 1 to 20 of 2293 Next ›
SQL Server Migration announcement
-
Link
Need help with migration to SQL Server? Have any questions related to SQL Server Migration Assistant (SSMA) products for Oracle/Sybase/MySQL/Access? Feel free to discuss any SQL Server migration related topics or post any questions related to SSMA.
