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 Votes
Please 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 | 33902 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
Filestream data 2008 to 2017
I am migrating databases from SQL Server 2008 to 2017. I have used backup and restore for some of them with success. I have a couple that contain Filestream data. I am having trouble with these. When ...Unanswered | 3 Replies | 353 Views | Created by iGBobH - Thursday, December 5, 2019 4:21 PM | Last reply by iGBobH - Friday, December 6, 2019 7:07 PM -
0 Votes
MySQL to SQL Server migration problem with connection string
Task > Import Data Wizard. The goal is to import data into SQL Server (running on a 64 bit platform) from an ODBC connection to a MySQL instance (running on a 32 bit ...Answered | 4 Replies | 12090 Views | Created by Kent Lewandowski - Wednesday, May 16, 2012 6:38 PM | Last reply by ShanayaS - Friday, December 6, 2019 6:41 AM -
0 Votes
Migrate from Oracle to SQL server and removing the SYSDB and ssma_oracle schema and all SSMA objects from target SQL Server
Hi, We are trying to migrate an oracle schema from Oracle 11gR2 database to SQL Database (SQL Server 2017 Azure ...Unanswered | 7 Replies | 674 Views | Created by sk_786 - Monday, December 2, 2019 9:20 PM | Last reply by Dedmon Dai - Friday, December 6, 2019 3:08 AM -
0 Votes
SSMA Migrating data from Oracle to SQL Server
Using SSMA Migrating data from Oracle to SQL Server. We already have created our new Azure SQL Server database essentially the same as the one we have on ...Answered | 2 Replies | 604 Views | Created by Greatwhite99 - Tuesday, December 3, 2019 3:02 PM | Last reply by Greatwhite99 - Thursday, December 5, 2019 1:21 PM -
0 Votes
Multiple access files to be migrated to SQL Server
Hi, I am new to DB, please help. I have been trying to migrate MS Access files (5 files) to sql server using SSMA 8.3.6. I can do it successfully for one of the ...Proposed | 2 Replies | 488 Views | Created by Sridhar Murthi - Thursday, November 28, 2019 5:44 AM | Last reply by Cathy Ji - Friday, November 29, 2019 6:04 AM -
0 Votes
How to bypass columns order Control by migrating from Oracle to MSSQL
I'm actually migrating an oracle database to MSSQL, the problem is that by several SQL tables the column Order is not the same like in Oracle tables. While migrating , the SSMA ...Unanswered | 1 Replies | 639 Views | Created by Brauprinz - Tuesday, November 26, 2019 1:10 PM | Last reply by Dedmon Dai - Wednesday, November 27, 2019 7:31 AM -
0 Votes
frequently SQL time out while calling CLR function
We have recently migrated the SQL server 2008 Standard edition to SQL server 2017 Standard edition. We have observing very frequently SQL time out while calling CLR function and it is impacting ...Unanswered | 2 Replies | 654 Views | Created by juniorkiran - Friday, November 22, 2019 3:14 PM | Last reply by Olaf Helper - Monday, November 25, 2019 9:47 AM -
0 Votes
Database Experimentation Assistant - Application Error
Hi, I've just installed Database Experimentation Assistant v2.6 on Win10, but when I start the program, it immediatly shows this application ...Unanswered | 2 Replies | 519 Views | Created by gcocci - Monday, November 18, 2019 9:45 AM | Last reply by Amelia Gu - Friday, November 22, 2019 9:36 AM -
0 Votes
Oracle to MSSQL Migration Special Characters issue
I'm using SSMA to migrate a database from Oracle to MSSQL. I have a problem with special Characters like ß=ss and also Empty space like "Expression" & "Expression ". While ...Unanswered | 2 Replies | 529 Views | Created by Brauprinz - Tuesday, November 19, 2019 9:19 AM | Last reply by Olaf Helper - Wednesday, November 20, 2019 7:11 AM -
0 Votes
How to Migrate SQL Server 2008 R2 with least amount of downtime and data loss?
Hi all, What is the best way to migrate a SQL database in the following scenario, minimizing downtime/data loss as much as ...Proposed | 2 Replies | 604 Views | Created by Robin Shanab - Wednesday, November 13, 2019 5:17 AM | Last reply by Cathy Ji - Thursday, November 14, 2019 7:48 AM -
0 Votes
Using SSMA TO MIGRATION ORACLE DB TO SQL SERVER DB
Hi this is a question about the ssma, I am using the ssma for oracle to migrate the oracle db into sql server db. but, when I try to ...Proposed | 4 Replies | 615 Views | Created by Tack880120 - Wednesday, November 13, 2019 6:35 AM | Last reply by Vaibhav-Chaudhari - Thursday, November 14, 2019 5:15 AM -
1 Votes
to make backup on the Azure and restore it locally
Hi I'm having database on Microsoft Azure and a local database. I need to make backup on the Azure, restore it locally and do something and then back it up locally and restore it on ...Answered | 1 Replies | 471 Views | Created by Barbi Rio - Wednesday, November 13, 2019 6:45 AM | Last reply by Shanky_621 - Wednesday, November 13, 2019 7:51 AM -
0 Votes
ssma Connection to Oracle failed. ORA-01017: invalid username/password; logon denied
I try to migrate oracle database to sql server using Microsoft SQL Server Migration Assistant 8.2 for Oracle, It is connected successfully in oracle sql database but it is not ...Proposed | 2 Replies | 638 Views | Created by susru - Monday, November 11, 2019 6:47 AM | Last reply by Amelia Gu - Tuesday, November 12, 2019 2:32 AM -
0 Votes
Error messages while migrating from Oracle to MSSQL
Hello together, I got these error messages when migrating from Oracle to MSSQL (Unfortunately, the error messages are in German languages) 1- Verletzung der ...Unanswered | 3 Replies | 784 Views | Created by Brauprinz - Tuesday, October 22, 2019 1:08 PM | Last reply by Alexander-Ivanov - Monday, November 11, 2019 5:14 PM -
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 | 7 Replies | 1816 Views | Created by RJ Timtiman - Thursday, June 20, 2019 8:00 AM | Last reply by susru - Monday, November 11, 2019 7:07 AM -
0 Votes
SQL server 2000 can be run on windows server 2016 or not ?
I have a windows server 2008 , running SQL server 2000 , and running very old application . As windows server 2008 will be EOL soon , I will upgrade windows server to 2016 , if I ...Proposed | 6 Replies | 839 Views | Created by patrick chan 701 - Tuesday, November 5, 2019 10:14 AM | Last reply by Amelia Gu - Friday, November 8, 2019 9:13 AM -
1 Votes
2008 to 2017 migration missing db objects
We are working on migration project which we migrate 2008 to 2018. After backup and restore we found objects(indexes,tables,views) missing in target 2018. what could be ...Unanswered | 5 Replies | 663 Views | Created by supersent - Thursday, November 7, 2019 9:03 AM | Last reply by Amelia Gu - Friday, November 8, 2019 8:23 AM -
0 Votes
Issues with bcp utility for loading data from file to table
Hi, This question might look generic but, I am facing issue with loading data from a file delimited with character § into a table using format file. I have to use format file ...Unanswered | 1 Replies | 593 Views | Created by Phaneendra Babu Subnivis - Tuesday, November 5, 2019 5:59 AM | Last reply by Dedmon Dai - Wednesday, November 6, 2019 7:15 AM -
0 Votes
Need a Script to Automate DB Restore
Hi all, Good day! Let me take a moment to ...Proposed | 1 Replies | 683 Views | Created by Justin_DBA - Tuesday, November 5, 2019 8:08 AM | Last reply by Dedmon Dai - Wednesday, November 6, 2019 6:44 AM -
0 Votes
Database Owner is changed after migrating SQL Server Database to Amazon RDS SQL Server
Hello all, I was trying to migrate a few databases to AWS RDS SQL Server (2017 Standard) using the AWS S3 bucket (Simple Backup-Restore). I was able to restore all the databases, ...Unanswered | 3 Replies | 682 Views | Created by TipsToKeep - Saturday, November 2, 2019 8:56 AM | Last reply by Tom Phillips - Tuesday, November 5, 2019 2:06 PM - Items 1 to 20 of 2318 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.