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 | 29186 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
KMS VAMT Supported DB Engine
I am currently planning on a redploy/migration of our KMS/VAMT installation. I would like to use a full install of MS Sql instead of express. I cannot find any documentation that ...Unanswered | 2 Replies | 43 Views | Created by Dan_15 - 21 hours 44 minutes ago | Last reply by Dan_15 - 17 hours 40 minutes ago -
0 Votes
Issues in importing .bacpac file
I am trying to importing a .bacpac of Azuare DB into a locally running SqlServer 2017 Enterprise edition. SqlServer is throwing the following error. I wonder if somebody ...Unanswered | 1 Replies | 42 Views | Created by vizardo - Monday, April 23, 2018 4:23 PM | Last reply by Mike Ubezzi (Azure) - Monday, April 23, 2018 7:09 PM -
0 Votes
Does SSMA for Oracle support TLS 1.1 or TLS 1.2?
Xp_ora2ms_exec2 fails with the following error when only TLS 1.1 or TLS 1.2 is enabled: SSL Security error ConnectionOpen (SECDoClientHandshake()). I ...Answered | 3 Replies | 91 Views | Created by ChryCheng - Friday, April 20, 2018 11:27 AM | Last reply by Alexander-Ivanov - Monday, April 23, 2018 4:14 PM -
0 Votes
UNICODE Support
Hi Team We are in the process of migrating existing DB2 Database to MSSQL. So in our existing application supports Unicode Data. They store Multi language data and also ...Proposed | 16 Replies | 101 Views | Created by Revathi jayakrishnan - Tuesday, April 17, 2018 10:23 AM | Last reply by Visakh16 - Wednesday, April 18, 2018 6:29 AM -
0 Votes
BCP Import and Export
I'm exporting a data from table to file through SQL BCP using following command. bcp test..Sample_Table out C:\Test\Test.dat -c -f C:\Test\TestFormat.fmt -S <servername> ...Unanswered | 3 Replies | 60 Views | Created by Revmkp - Tuesday, April 17, 2018 9:40 AM | Last reply by Visakh16 - Tuesday, April 17, 2018 10:15 AM -
4 Votes
CDW from 2016 to 2017 ends with "Property HasMemoryOptimizedObjects is not available for Database"
Hi I'm trying to copy a couple of databases from a SQL2016 to SQL2017 using the Copy Database ...Proposed | 9 Replies | 769 Views | Created by HSTD76 - Monday, November 13, 2017 4:52 PM | Last reply by Ruud Lenders - Monday, April 16, 2018 10:55 PM -
0 Votes
Downgrading SQL Server with Always On from Enterprise to Developer Edition
Hi Friends, I am going to downgrade one of the box (where Always On is configured) from SQL Server Enterprise edition to Developer Edition. what are the important points to keep in ...Proposed | 7 Replies | 144 Views | Created by Prince Rastogi - Friday, April 13, 2018 11:35 AM | Last reply by Martin.Cairney - Monday, April 16, 2018 12:06 PM -
0 Votes
Merging two TFS databases
We have 2 TFS environments used by two different applications having different set of users. One is TFS 2015 & Another is TFS 2017, we need to merge both of them into one ...Discussion | 1 Replies | 255 Views | Created by Amit _Sen - Wednesday, February 21, 2018 12:15 PM | Last reply by 2Power - Friday, April 13, 2018 7:23 PM -
0 Votes
SQL 2012 upgrade.
Hi All, We want to update SQL 2012 SP4 express edition to standard edition. Express edition instance already hosted the SCCM(System center configuration manager) data base. it ...Answered | 4 Replies | 95 Views | Created by Sreenivas C - Tuesday, April 10, 2018 2:13 PM | Last reply by Shanky_621 - Tuesday, April 10, 2018 2:40 PM -
0 Votes
SQL database migration on new storage
Hi, Is it possible to migrate SQL database on new storage? we have Always on enabled on SQL 2014 and its 4 nodes Windows 2012 R2 cluster. Now we want to ...Answered | 3 Replies | 125 Views | Created by Kuldeep Mehra - Tuesday, April 10, 2018 8:26 AM | Last reply by Shanky_621 - Tuesday, April 10, 2018 1:18 PM -
0 Votes
In place upgrade SQL 2016 to SQL 2017
Hello All - I am trying to gather all the information before starting in place upgrade process of SQL 2016 to SQL 2017. Here is the network layout. OS - Windows Server ...Proposed | 4 Replies | 147 Views | Created by LANHD - Thursday, April 05, 2018 6:30 PM | Last reply by Pirlo Zhang - Tuesday, April 10, 2018 8:55 AM -
0 Votes
SSMA - tablespace change
Hello We are trying to migrate the Oracle DB Scripts to MSSQL Server using SSMA. So is it possible to have the same Tablespace mentioned in SQL ...Answered | 3 Replies | 120 Views | Created by Revathi jayakrishnan - Monday, April 09, 2018 10:02 AM | Last reply by Alexander-Ivanov - Monday, April 09, 2018 6:42 PM -
0 Votes
DB2 -SSMA7.7 got an error " Error occurred while collecting data."
System.Data.OleDb.OleDbException: No authorized routine named "GETVARIABLEFUNCTIO" of type "" having compatible arguments was found. SQLSTATE: 42884, SQLCODE: ...Unanswered | 3 Replies | 149 Views | Created by Satya Ramakuri - Thursday, March 29, 2018 3:12 PM | Last reply by Alexander-Ivanov - Monday, April 09, 2018 3:39 PM -
0 Votes
Migration SQL Server 2000 to SQL server 2008 R2
How to migrate SQL server 2000 Database to Sql server 2008 R2 database, what will be risk and mitigation has to be taken care of and what are changes to be required in query after migration.Unanswered | 2 Replies | 262 Views | Created by Hemants15 - Wednesday, February 28, 2018 4:44 AM | Last reply by Shanky_621 - Monday, April 09, 2018 9:59 AM -
0 Votes
SQL Database Migration Steps from 2008 r2 to 2014
Hi All, Could you please let me know the steps to migrate databases from 2008 r2 to 2014. what the necessary actions which needs to be taken ...Unanswered | 5 Replies | 167 Views | Created by Aravind 18 - Saturday, March 31, 2018 1:14 AM | Last reply by Jason_Clark03 - Monday, April 09, 2018 9:09 AM -
0 Votes
Generate Script for Event Notification - SQL Server 2012
I need to migrate my Event Notifications from current server to another one. I would like to generate that code, but I couldn't find an way to do that. Try ...Unanswered | 2 Replies | 177 Views | Created by Rafael Dontal - Friday, March 16, 2018 10:13 AM | Last reply by Rafael Dontal - Tuesday, March 27, 2018 8:44 AM -
0 Votes
Consolidation load testing
Please let me know if this is the right forum for this topic. Generally how do you test whether a target virtual server can handle workloads consolidated from SQL Server instances on multiple ...Unanswered | 2 Replies | 154 Views | Created by District9 - Thursday, March 22, 2018 7:11 PM | Last reply by District9 - Friday, March 23, 2018 3:52 PM -
1 Votes
Can we script out all linked Servers at single go? is there any script available?
Hi All, We are migrating SQL 2008 instances to SQL 2014. Looking for help regarding Linked Servers. Is there a way to script out all linked ...Unanswered | 5 Replies | 1111 Views | Created by Samantha v - Sunday, August 30, 2015 9:14 PM | Last reply by The Mackin - Thursday, March 22, 2018 9:37 PM -
0 Votes
Cannot connect to remote Sql Server and getting Timeout error
Recently I have installed SQL Server 2008 R2 and I am trying to connect from my local to 'HD-DEV-GP' server and getting below error. Please find the attached scree shot for your ...Proposed | 1 Replies | 125 Views | Created by RamiReddy.com - Thursday, March 22, 2018 9:10 AM | Last reply by Visakh16 - Thursday, March 22, 2018 9:20 AM -
0 Votes
migrate databases between SQL 2014 SP2 server with different CU levels?
We want to either copy a database or backup/restore database from A) sql 2014 (SP2-GDR)(12.0.5571.0) to B) sql 2014 (SP2-GDR)(12.0.5207.0). This database is being moved from A ...Unanswered | 15 Replies | 185 Views | Created by kimdav111 - Wednesday, March 21, 2018 6:27 AM | Last reply by Kumar muppa - Thursday, March 22, 2018 12:44 AM - Items 1 to 20 of 2049 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.
