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.
-
0 Votesmoving certificate and symmetric keys between servers
We migrated our databases to a new server (both are Win 2008 R2). I backup previous databases, restore on the new server with full recovery mode. While clients' emails and password are ...Answered | 6 Replies | 2052 Views | Created by new SQLServer user - Friday, November 8, 2013 6:38 PM | Last reply by Sean Gallardy - 16 hours 19 minutes ago
-
0 Votes
SQL server 2012 to 2016 120 to 130 Compatibility/Query store
Enable the Query store >Left the compatibility to 2012 >run the queries >then change the compatibility to ...Unanswered | 5 Replies | 72 Views | Created by chinna738 - 19 hours 2 minutes ago | Last reply by Shanky_621 - 17 hours 13 minutes ago -
0 Votes
Migrate/Downgrade AX database from SQL2017 to SQLServer2016
Hello Everyone, I am new in this forum so I hope you guys have a little patience with me. My inquiry is very straight forward so It'll be quick: I have installed ...Proposed | 9 Replies | 155 Views | Created by PLNestor - Friday, February 14, 2020 2:14 PM | Last reply by Laxmidhar sahoo - 17 hours 53 minutes ago -
0 Votes
Unable to read HEIC file after installing Image Extensions
Get. Afterwards it said "This Product is Installed". When I clicked on an HEIC file it launched Photos, but gave the message, "IMG_3561.HEIC We can't open this file." I ...Unanswered | 3 Replies | 133 Views | Created by jmarkfoley - Friday, February 14, 2020 3:24 PM | Last reply by Amelia Gu - Monday, February 17, 2020 5:33 AM -
0 Votes
Cant restore from backup, script, or copying database on to asp site from localhost or asp project
I have tried changing permissions for the database and log file. I have scripted the database out and tried running the script on website (has gotten me further but new errors like Logins ...Answered | 7 Replies | 328 Views | Created by j-howard3 - Tuesday, February 11, 2020 5:29 AM | Last reply by j-howard3 - Monday, February 17, 2020 3:44 AM -
0 Votes
SQL 2014 VM - Domain Change - Impact Analyses Template/ideas?
Good day,i need help please. Current Architecture is VM (Off Site) in a data center with SQL 2014 (SSMS, SSIS, SSAS OLAP, SSAS Tabular) + VS2014 SSDT with ...Answered | 5 Replies | 386 Views | Created by Ismailc1 - Friday, February 7, 2020 5:44 PM | Last reply by Ismailc1 - Saturday, February 15, 2020 4:16 PM -
0 Votes
Could not execute statement on remote server 'HDDDEV'.
call procedure in sqlserver queryUnanswered | 1 Replies | 218 Views | Created by tlsdbwjd98 - Thursday, February 13, 2020 12:45 AM | Last reply by Amelia Gu - Friday, February 14, 2020 6:32 AM -
0 Votes
How to reconnect old log file to mdf file?
I have an MDF (Orig.mdf) file and LDF (Orig_log.ldf) file from before. I was encountering an out-of-memory error and I thought the reason was because of the large log file. So I ended up renaming the ...Answered | 9 Replies | 1127 Views | Created by OCS.New - Thursday, May 23, 2019 6:20 AM | Last reply by Villiam Luther - Wednesday, February 12, 2020 8:20 AM -
0 Votes
SQL Server Database Downgrade
Hello- I need to downgrade from SQL 2019 to SQL 2016 due to untested capabilities with software I'm running. I have an existing database that I need to migrate from 2019 to 2016. ...Proposed | 4 Replies | 292 Views | Created by shaqui - Thursday, February 6, 2020 9:32 PM | Last reply by Dawn Yang - Tuesday, February 11, 2020 11:02 AM -
0 Votes
Migrating from OFF-Premisses (VM in Data Center) to Azure
Good day,i need help please. Current Architecture is VM (Off Site) in a data center with SQL 2014 (SSMS, SSIS, SSAS OLAP, SSAS Tabular) + VS2014 SSDT with ...Answered | 3 Replies | 349 Views | Created by Ismailc1 - Friday, February 7, 2020 5:42 PM | Last reply by Ismailc1 - Monday, February 10, 2020 8:58 PM -
0 Votes
SQL 2012 Cluster migration to SQL 2017
A co-worker and I are tasked with migrating multiple instances on a physical, two node SQL server 2012 cluster with high availability groups to a new SQL server 2017 cluster. We have downloaded ...Unanswered | 5 Replies | 422 Views | Created by PunsRUs - Friday, January 31, 2020 5:07 PM | Last reply by Cathy Ji - Wednesday, February 5, 2020 9:35 AM -
0 Votes
Identity attribute is missing in all the tables after back and restore f the database SQL server2016
Hi All, I tried to backup and restore a database from one SQL server to another. Sql server version is 2016. Almost all my tables has Identity enabled in the ...Unanswered | 1 Replies | 200 Views | Created by RadhaApo - Monday, February 3, 2020 6:41 PM | Last reply by Tom Phillips - Monday, February 3, 2020 7:05 PM -
0 Votes
Instance migration with replication enabled - most efficient way?
Hi all I have a SQL Server 2016 instance with 5 databases set up with transactional replication to another SQL Server 2016 instance. I am looking to upgrade both ...Unanswered | 3 Replies | 353 Views | Created by warnerrj79 - Thursday, January 30, 2020 1:02 PM | Last reply by warnerrj79 - Friday, January 31, 2020 11:40 AM -
3 Votes
SQL Enterprise to Standard 2016 Downgrade
Hello, We are trying to downgrade some of our sql instances from enterprise to standard on our test environment before moving to production i ran this query ...Proposed | 4 Replies | 1493 Views | Created by shan.ferouze - Wednesday, March 6, 2019 5:57 AM | Last reply by NRS123 - Wednesday, January 29, 2020 5:42 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 | 4 Replies | 1551 Views | Created by Leandro_Martins_de_Lima - Thursday, July 4, 2019 8:34 PM | Last reply by Leandro_Martins_de_Lima - Monday, January 27, 2020 4:41 PM -
0 Votes
Service Master Key Initialization
Hi all. I am doing a test SQL Server instance migration from 2017 to 2019. This includes migrating the master, model and msdb databases. All has gone smoothly, ...Answered | 7 Replies | 477 Views | Created by warnerrj79 - Wednesday, January 22, 2020 4:29 PM | Last reply by warnerrj79 - Thursday, January 23, 2020 5:33 PM -
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 ...Proposed | 4 Replies | 1770 Views | Created by vizardo - Monday, April 23, 2018 4:23 PM | Last reply by Mike Ubezzi (Azure) - Thursday, January 23, 2020 4:49 PM -
0 Votes
SQL Server to Azure Managed Instance
If I use one of the methods to migrate a SQL server instance with several databases into a Azure Managed Instance, would the procedure also replicate any login accounts with access rights? Particular ...Proposed | 3 Replies | 516 Views | Created by Java_MCSE - Tuesday, January 14, 2020 10:22 AM | Last reply by Amelia Gu - Friday, January 17, 2020 4:19 AM -
0 Votes
Cannot get Restored Databases out of (Restoring) mode
I've upgraded from SQL Server 2014 to 2019. In the 2014 instance I had 2 archived databases in Standby / Read-only mode: HPRS2018 and HPRS2019. These were archive/reference snapshots of the production ...Unanswered | 4 Replies | 561 Views | Created by jmarkfoley - Monday, January 13, 2020 4:46 AM | Last reply by Cris Zhan - Tuesday, January 14, 2020 9:23 AM -
0 Votes
MS SQL Server 14 recovery
Hello couple days ago my pc with Ms SQL Server 14 broke, probably due to latest updates, well I installed on new hardrive new copy of windows and copied server and data from: "D:\Program ...Proposed | 3 Replies | 520 Views | Created by speed258 - Friday, January 10, 2020 6:57 AM | Last reply by Cathy Ji - Friday, January 10, 2020 10:05 AM - Items 1 to 20 of 2346 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.
