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.
-
1 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 | 28596 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
SSMA report generation
Hello all, When creating the assessment from the source database such Mysql does SSMA physically converts the schema within MySQL instance?Unanswered | 1 Replies | 34 Views | Created by ghostme - 15 hours 1 minutes ago | Last reply by Lin Leng - 46 minutes ago -
0 Votes
MYSQL To SQL Server Data type mapping
Dear all , I am currently doing a migration assessment of MySQL to SQL Server database. I wanted to know if there is any reference documentation of data types, ...Answered | 2 Replies | 46 Views | Created by ghostme - Tuesday, October 17, 2017 5:44 AM | Last reply by ghostme - 12 hours 49 minutes ago -
0 Votes
SQL Server slow running Windows 7 with RDP
My client moved a server to a hosted environment. Prior the data connection was satisfactory. After the move the data is very slow. Any suggestions to improve speed.Unanswered | 2 Replies | 70 Views | Created by SystemLink Globla - Wednesday, October 11, 2017 3:43 PM | Last reply by Teige Gao - Thursday, October 12, 2017 6:35 AM -
0 Votes
how to speed up data migration of large tables (> 1 mio rows)
10 mio rows)? Paralell processing, bulk processing, etc? Thank you for support. AndreasUnanswered | 13 Replies | 266 Views | Created by Andreas.007 - Friday, September 22, 2017 9:23 AM | Last reply by Selvi Naidu - Wednesday, October 11, 2017 12:18 PM -
0 Votes
SSMA - Oracle Instantclient or Full Client ?
Hi Just trying to set up SSMA for Oracle. Have downloaded SSMA V7.6 and set it up on a Windows Server 2012 R2 (x64). SQL Server 2014 ...Answered | 4 Replies | 105 Views | Created by IWDukes - Tuesday, October 10, 2017 10:37 PM | Last reply by IWDukes - Wednesday, October 11, 2017 7:21 AM -
0 Votes
Sharepoint Database migration to new systems
Our Sharpoint 2013 databases are on SQL 2012 based single server with two more Databases of K2 Workflow under one instance. we prepared SQL 2012 AlwaysON Availability groups on two ...Unanswered | 1 Replies | 148 Views | Created by Genius1985 - Saturday, October 07, 2017 8:25 PM | Last reply by Lin Leng - Monday, October 09, 2017 5:14 AM -
1 Votes
DAO for SSMA 7.4
I am trying to use SSMA to upsize some Access databases (2010 and 2016) to SQL Server (2016). I am running Windows 10 with Office 2016 (Office Proplus 365 locally ...Answered | 9 Replies | 737 Views | Created by Paddy Boocock - Tuesday, July 11, 2017 10:01 AM | Last reply by Olaf Helper - Saturday, October 07, 2017 3:40 AM -
0 Votes
SAN migration for SQL 2012 Guest VM Cluster
I have the following setup and want to perform a migration from one SAN to another. Host VM host: Host server x 3 running Windows 2012 ...Unanswered | 2 Replies | 158 Views | Created by Joseph TK Liu - Monday, September 25, 2017 7:58 AM | Last reply by Joseph TK Liu - Friday, October 06, 2017 8:55 AM -
0 Votes
Hi, In my trying to create .dacpac file for Azure V12 from my application, due to Synonyms with other database getting version error , please help to resolve this.
TITLE: Microsoft SQL Server Management Studio ------------------------------ Could not deploy package. Error SQL72014: .Net ...Unanswered | 1 Replies | 89 Views | Created by Ratan Ghosh - Thursday, October 05, 2017 7:42 AM | Last reply by Lin Leng - Friday, October 06, 2017 7:43 AM -
0 Votes
Hi, I am trying to move my local database to azure Pass Service, While trying to generate .bacpac file it's giving error due to Synonyms with other database. please help to resolve this, or is there any process that we can move two database together.
TITLE: Microsoft SQL Server Management Studio ------------------------------ One or more unsupported elements were found in the schema used as ...Discussion | 1 Replies | 104 Views | Created by Ratan Ghosh - Thursday, October 05, 2017 7:24 AM | Last reply by Kapil.Kumawat - Thursday, October 05, 2017 9:04 AM -
0 Votes
how does SSMA assure that consistent set of data is retrieved from Oracle
Hi I plan to migrate from Oracle 11 to SQL Server 2017. (How) does SSMA for Oracle Data Migration assure that a consistent set of ...Answered | 2 Replies | 158 Views | Created by Andreas.007 - Friday, September 22, 2017 9:35 AM | Last reply by Andreas.007 - Friday, September 22, 2017 5:43 PM -
0 Votes
how does SSMA assure that consistent set of data is retrieved from Oracle
Hi I plan to migrate from Oracle 11 to SQL Server 2017. (How) does SSMA for Oracle Data Migration assure that a consistent set of ...Answered | 4 Replies | 177 Views | Created by Andreas.007 - Friday, September 22, 2017 9:34 AM | Last reply by Andreas.007 - Friday, September 22, 2017 12:53 PM -
0 Votes
duplicate key value is NULL
Hi During data migration of a table I get the following error: Violation of UNIQUE KEY constraint .... Cannot insert duplicate key in object .... The duplicate ...Answered | 4 Replies | 230 Views | Created by Andreas.007 - Thursday, September 21, 2017 7:19 PM | Last reply by Hannah Yu - Friday, September 22, 2017 9:16 AM -
2 Votes
Restoring a .bak file with more mdf files inside
Hi, I am trying to restore a database that has 5 mdf files and one ldf. I don't get any error message but its stuck..When I check the progress ...Answered | 11 Replies | 219 Views | Created by melimelo15 - Wednesday, September 20, 2017 9:39 AM | Last reply by Andreas Kreuzberg - Friday, September 22, 2017 6:56 AM -
0 Votes
SSMA for Oracle: data migration stops with 'value is null' error
Hi I am using SSMA for Oracle v7.5.0. And I am using 'Oracle Client Provider' to connect to Oracle 12. dData migration for some tables stops with 'The value is ...Answered | 2 Replies | 194 Views | Created by Andreas.007 - Thursday, September 21, 2017 4:31 PM | Last reply by Andreas.007 - Thursday, September 21, 2017 6:17 PM -
0 Votes
Upgrade existing instance of SQL 2008(SP4) to SQL2014 errors
Currently trying to upgrade an existing SQL 2008(SP4) instance to SQL 2014 and getting the following errors. I'm fairly new to SQL and struggling a little to figure out what the issue might ...Unanswered | 14 Replies | 1557 Views | Created by philm36 - Saturday, May 02, 2015 6:41 PM | Last reply by melimelo15 - Thursday, September 21, 2017 10:59 AM -
0 Votes
Upgrade MSSQL database server from 2005 to 2012
Currently our production application running with MSSQL database 2005. application running fine for nearly 5 years. now we need to upgrade the database to ...Proposed | 13 Replies | 289 Views | Created by Dunstan Eranga - Monday, September 18, 2017 7:10 AM | Last reply by Tom Phillips - Wednesday, September 20, 2017 1:03 PM -
0 Votes
SSMA: are indexes disabled during migration?
Trying to work on migration performance. Does anyone know if the Project Setting | Migration | Check constraints = False also includes Index or only Alter Table constraints? The definition of a index ...Unanswered | 1 Replies | 167 Views | Created by CWinKY_2017 - Monday, September 18, 2017 8:13 PM | Last reply by Teige Gao - Tuesday, September 19, 2017 1:58 AM -
0 Votes
SQL cluster SAN migration
I have a Hyper-V cluster with 3 hosts connecting to a SAN. Inside them, there are two SQL 2012 VM servers running in cluster mode using virtual fiber channel. The disks used are also connected to the ...Unanswered | 2 Replies | 322 Views | Created by Joseph TK Liu - Thursday, June 22, 2017 3:35 AM | Last reply by Joseph TK Liu - Tuesday, September 19, 2017 1:43 AM -
0 Votes
MySQL to MSSQL null date errors
Date to Date --> datetime2 but that made no difference. I can find no setting where I can write a constant date to MSSQL instead of a zero date and Googling ...Answered | 3 Replies | 359 Views | Created by BobInCT - Sunday, September 03, 2017 1:16 PM | Last reply by Alexander-Ivanov - Monday, September 18, 2017 10:14 PM - Items 1 to 20 of 1957 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.
