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 | 28343 Views | Created by edhickey - Wednesday, April 28, 2010 11:16 PM | Last reply by Carlos Augusto- - Thursday, October 13, 2011 4:34 PM
-
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 | 7 Replies | 316 Views | Created by Paddy Boocock - Tuesday, July 11, 2017 10:01 AM | Last reply by Paddy Boocock - 9 hours 51 minutes ago -
1 Votes
move data files
my laptop crashed but i have a full backup of the drive. how can i restore the sql server data into another laptop. i have all the files from the drive backup but they are the entire folder of the ...Proposed | 3 Replies | 140 Views | Created by The World is mine - Monday, August 14, 2017 2:13 AM | Last reply by Hannah Yu - Tuesday, August 15, 2017 2:20 AM -
1 Votes
Error Migrating Data Error occurred while inserting table information into Data Migration Auxiliary table
Hello, I am attempting to migrate a table from an Oracle database to an SQL 2012 database. I am able to create the table in the SQL database, but when I try to migrate the ...Answered | 4 Replies | 1930 Views | Created by MillerTim - Tuesday, January 19, 2016 6:30 PM | Last reply by Andrey84 - Monday, August 14, 2017 7:29 PM -
0 Votes
Sequence in Sql Server
Hello, <o:p></o:p> Have Prepared the structure of format(.fmt) file similar to Oracle control file. Just want to check Is there any option ...Unanswered | 1 Replies | 126 Views | Created by rshanker - Tuesday, August 08, 2017 6:54 AM | Last reply by Aung Mon Chit Htwe - Tuesday, August 08, 2017 7:08 AM -
0 Votes
Required assistance to Migrate 2TB DB from Oracle to SQL server
Dear All, I need a assistance from you that we have 2 TB Size of database which is running on Oracle which need to be ...Proposed | 2 Replies | 128 Views | Created by mailatdinesh - Monday, July 31, 2017 6:05 AM | Last reply by Teige Gao - Tuesday, August 01, 2017 8:37 AM -
0 Votes
SQL User Account permissions.
Hi All, If user is part of the AD group and group provided with sysadmin permission. same user added as separately in security logs as "Public" server role ...Answered | 3 Replies | 124 Views | Created by Sreenivas C - Thursday, July 27, 2017 6:09 PM | Last reply by Olaf Helper - Friday, July 28, 2017 5:34 AM -
0 Votes
A bug in SSMA for MySQL converting view
look at following original mysql view and converted script, has following issues: 1. literal 'Delete' is converted to 0 in two ocassions 2. a order by clause is ...Unanswered | 1 Replies | 105 Views | Created by mikebroojeni - Wednesday, July 26, 2017 7:44 PM | Last reply by Lin Leng - Thursday, July 27, 2017 9:27 AM -
0 Votes
Bug in SSMA for MySql
Following storedprocedure during first phase generates no concerns, but at the time of synchronizing to SQL fails to create the routine because of syntax error SET `Column1` ...Unanswered | 1 Replies | 97 Views | Created by mikebroojeni - Wednesday, July 26, 2017 7:21 PM | Last reply by Teige Gao - Thursday, July 27, 2017 6:01 AM -
0 Votes
Creating non clustered indexes taking longer time in sql server 2012
Hi, We have recently migrated from Sql server 2008 r2 to Sql server 2012. As a part of migration we have upgraded the hardware in the new server to use 8 GB RAM and 4 ...Unanswered | 2 Replies | 167 Views | Created by Sheethal Kamasetty - Thursday, July 20, 2017 5:48 AM | Last reply by Satish Kumar Gajula - Wednesday, July 26, 2017 1:13 PM -
0 Votes
SSMA for oracle painfully slow when moving data to SQLserver 2016
I 'm trying to move data over from Oracle DB hosted at AWS to SQL Server 2016. The "Microsoft SQL Server Migration Assistant for oracle v7.4" tool has been invaluable ...Unanswered | 4 Replies | 240 Views | Created by rshanker - Monday, July 10, 2017 1:48 PM | Last reply by Alexander-Ivanov - Wednesday, July 26, 2017 12:30 AM -
0 Votes
SSMA for Sybase: Server to Server fails using ADO.NET provider
Has anybody had success in doing Server to Server data migration using the ADO.NET data provider? I have not, I get the following error: Unable to find ADO .Net Provider files - ...Unanswered | 8 Replies | 298 Views | Created by CWinKY_2017 - Friday, July 07, 2017 11:40 PM | Last reply by Hilary Cotter - Saturday, July 22, 2017 7:54 PM -
0 Votes
Attaching a database without database_fs_doc.md
Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\PMDB1_fs_doc.mdf". Operating system error 2: "2(The system cannot find the file ...Proposed | 3 Replies | 239 Views | Created by walidkilani - Thursday, July 20, 2017 11:58 AM | Last reply by Olaf Helper - Friday, July 21, 2017 3:29 PM -
0 Votes
SQL Server: Data conversion failed
I'm using SQL Server Import Wizard to import a flat csv file(exported from oracle Database) into one table of Sql server. When trying to Import data getting below error through ...Proposed | 1 Replies | 134 Views | Created by rshanker - Thursday, July 20, 2017 1:47 PM | Last reply by Teige Gao - Friday, July 21, 2017 2:18 AM -
3 Votes
Move all databases to new Server
Hi All, I have an SQL server which has a number of OS issues and the only way to resolve these is a OS rebuild. Because of this I'm looking to build a ...Answered | 3 Replies | 209 Views | Created by Robert Pollock - Thursday, July 20, 2017 11:23 AM | Last reply by Satish Kumar Gajula - Thursday, July 20, 2017 1:33 PM -
0 Votes
Migrate SQL 2012 Failover Cluster to another forest
Hi Guys How can we migrate a SQL 2012 fail-over cluster to another forest? Is this supported? Can ADMT be ...Proposed | 2 Replies | 471 Views | Created by The Exchanger - Monday, October 24, 2016 5:15 PM | Last reply by rioxx - Thursday, July 20, 2017 7:54 AM -
0 Votes
SQL Database move from SQL 2008 to SQL 2014
Hi All, We have moved "Application Database from SQL 2008 to SQL 2014". we have issues after moving to new SQL version. We want to move the SQL DB back to old SQL 2008 ...Unanswered | 5 Replies | 187 Views | Created by Sreenivas C - Tuesday, July 18, 2017 3:27 PM | Last reply by Olaf Helper - Thursday, July 20, 2017 5:36 AM -
3 Votes
Big tables from MySql to MSSql error Connection timeout
HI, I have a big database around 46GB in Mysql format and I managed to convert all the database to MSsql except two tables, the biggest ones. When I try to migrate those 2 tables, ...Unanswered | 6 Replies | 1701 Views | Created by edyy2us - Friday, July 04, 2014 2:27 PM | Last reply by Raaghul - Tuesday, July 18, 2017 2:47 AM -
0 Votes
SQL server 2012 to SQL 2016
Hello All, Currently, we are using below version detail of SQL server in the production environment and would like to upgrade to SQL 2016 Microsoft ...Answered | 2 Replies | 159 Views | Created by Anupam Soni02 - Monday, July 17, 2017 4:55 AM | Last reply by Olaf Helper - Monday, July 17, 2017 7:03 AM -
0 Votes
SQL Server 2016 Upgrade Fails to start
Trying to upgrade our production sql server enterprise instance today and get the following error. I've rebooted and tried a repair install but got the same error. The Engine ...Unanswered | 1 Replies | 199 Views | Created by dougleu - Saturday, July 15, 2017 7:27 PM | Last reply by Lin Leng - Monday, July 17, 2017 4:57 AM -
0 Votes
Migration - SQL Server 2008 SP2 to SQL Server 2014 SP2
Our current server A is running SQL Server 2008 SP2 R2 with 2 Databases there which we are planning to migrate to a new server B which is running on SQL Server 20014 ...Answered | 5 Replies | 200 Views | Created by Frank Foo - Tuesday, July 11, 2017 7:56 AM | Last reply by Olaf Helper - Friday, July 14, 2017 1:32 PM - Items 1 to 20 of 1928 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.
