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 | 28717 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
SQL SERVER 2008 R2 to SQL SERVER 2016
Hi Team, Thanks for your support! We require to migrate from SQL SERVER 2008 R2(windows server 2008 R2) to SQL SERVER 2016(windows server ...Proposed | 4 Replies | 83 Views | Created by DuraimuruganDhanaraj - Wednesday, December 06, 2017 10:38 AM | Last reply by DuraimuruganDhanaraj - Thursday, December 07, 2017 8:36 AM -
0 Votes
Is there incremental backup taken the DMA tool for the on-premise to AZURE SQL Database migration.?
We have doing on-prem to azure sql PaaS using DMA tool.so in this migration.. DMA (Data Migration Assistant )tool not taken incremental backup.could you please help me, how can we taken incremental ...Unanswered | 2 Replies | 70 Views | Created by Pramod F - Wednesday, December 06, 2017 1:01 PM | Last reply by Lin Leng - Thursday, December 07, 2017 3:09 AM -
0 Votes
Can I configure SSMA to use DB2 server_encrypt authentication?
I am trying to use Microsoft SQL Server Migration Assistant (SSMA) for DB2 (version 7.5.0) to migrate a DB2 11.1 database to MS SQL 2014. The DB2 connection used to work, but fails after the ...Unanswered | 3 Replies | 71 Views | Created by Rick Grant - Tuesday, December 05, 2017 6:04 PM | Last reply by Teige Gao - Thursday, December 07, 2017 1:51 AM -
0 Votes
SSMA for Oracle copy an existing project
I need to make several runs in my migration project because of large tables that cannot be migrated at once. Is there a way to easily copy an existing project so that I can modify ...Answered | 6 Replies | 110 Views | Created by mklaey - Wednesday, November 29, 2017 1:59 PM | Last reply by mklaey - Monday, December 04, 2017 7:54 PM -
2 Votes
Migrating a database from a higher maintenance release number to a lower maintenance release number MS SQL server
Edit: Upon checking on version numbering I initially described the question wrong. Corrected title and question to represent this. I have two SQL servers, one ...Answered | 3 Replies | 77 Views | Created by J.Jones_ - Monday, December 04, 2017 10:54 AM | Last reply by Olaf Helper - Monday, December 04, 2017 11:39 AM -
0 Votes
SQL - copy one column from one database to another database.
Hello Everyone, I made bad update in my database (1 column) I can not restore from point in time :( I have backup (from 2 ...Proposed | 4 Replies | 75 Views | Created by AleksanderKep - Monday, December 04, 2017 8:56 AM | Last reply by DIEGOCTN - Monday, December 04, 2017 11:08 AM -
0 Votes
Migration of sqlserver from a named instance on one server into Default instance on the new server
We are trying to do migrate <g class="gr_ gr_48 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="48" ...Proposed | 2 Replies | 119 Views | Created by VijayaNettem - Friday, December 01, 2017 6:17 AM | Last reply by Hilary Cotter - Friday, December 01, 2017 4:35 PM -
0 Votes
Mapping default datatypes...
SSMA for MySQL v7.6. The tool allows you to map: from bigint to bigint from date to date from decimal to ...Proposed | 3 Replies | 173 Views | Created by This display name is already in use. Please ch00se - Thursday, November 02, 2017 12:51 PM | Last reply by Teige Gao - Friday, December 01, 2017 8:28 AM -
0 Votes
"Counting Objects to be loaded" issue - SSMA for Oracle v7.6.0
Hello, Hope somebody will be able to help out... Once I connect to my Oracle ...Answered | 4 Replies | 211 Views | Created by soti84 - Monday, November 06, 2017 1:58 PM | Last reply by soti84 - Tuesday, November 28, 2017 9:47 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 | 10 Replies | 1066 Views | Created by Paddy Boocock - Tuesday, July 11, 2017 10:01 AM | Last reply by ASSEDO Daniel - Monday, November 27, 2017 4:18 PM -
0 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 | 3 Replies | 176 Views | Created by HSTD76 - Monday, November 13, 2017 4:52 PM | Last reply by Lin Leng - Wednesday, November 22, 2017 4:55 AM -
0 Votes
Move From SQL server 2014 enterprise edition to SQL server 2016 Standard Edition
Hi All, My company decided to downgrade the SQL server instances from SQL server 2014 enterprise Edition to SQL Server 2016 Standard ...Answered | 2 Replies | 123 Views | Created by LpSas - Monday, November 20, 2017 2:41 PM | Last reply by Teige Gao - Tuesday, November 21, 2017 2:44 AM -
0 Votes
Data Tools - Scheduling
Good afternoon, Is there a way to schedule a Data Tier Application extraction via SQL Server or Data tools? We would like a way to schedule extractions overnight vs. having to do ...Answered | 1 Replies | 96 Views | Created by MichelleLG3 - Wednesday, November 15, 2017 7:54 PM | Last reply by Ousama EL HOR - Wednesday, November 15, 2017 8:01 PM -
0 Votes
Unable to migrate SQL server encrypted views and triggers in database
Hi Expert, Need help on "migrate SQL server encrypted views and triggers in database to Azure" . I am trying to create a ".bacpac" file but its throwing ...Proposed | 1 Replies | 132 Views | Created by DMoitra - Friday, November 10, 2017 12:35 PM | Last reply by SQLRockstar - Friday, November 10, 2017 4:12 PM -
0 Votes
SQL Server 2016 - Install on Windows 2016 Server?
We are installing a windows SQL 2016 Server and we want to install windows SQL 2016 on a Windows 2016 Server. Looking at the Volume licensing it appears it says Windows SQL 2016 runs on Windows ...Answered | 3 Replies | 160 Views | Created by ClarkInIt - Thursday, November 09, 2017 10:06 PM | Last reply by Shanky_621 - Friday, November 10, 2017 7:40 AM -
0 Votes
How to configure data migration tool when trying to migrate large tables
558158451 AND "S$$$$$$$D"Proposed | 1 Replies | 169 Views | Created by feelbd - Wednesday, November 08, 2017 11:46 PM | Last reply by Lin Leng - Thursday, November 09, 2017 2:46 AM -
0 Votes
Move databases to larger storage
Hi, Storage E: which we use for database hasn't a lot of free space, so we decided to move databases to new larger storage, below ...Proposed | 5 Replies | 152 Views | Created by poldek111 - Tuesday, November 07, 2017 11:32 AM | Last reply by Tom Phillips - Tuesday, November 07, 2017 12:51 PM -
1 Votes
SQL Server 2008 R2 upgrade to new version
Hi We have business critical databases and require to migrate to new version. But I understand there was an application developed and no one know how to support when its brake ...Proposed | 14 Replies | 652 Views | Created by ashwan - Monday, October 30, 2017 3:26 AM | Last reply by Alizine - Tuesday, November 07, 2017 11:40 AM -
0 Votes
SSMA 7.5 Installation problems
I'm trying to get SSMA working with SQL Server 2016 Express. I have wasted more than a day trying to install SSMA 7.5 (The Access to SQL Server ...Answered | 17 Replies | 808 Views | Created by Ken Evans - Sunday, August 27, 2017 3:28 PM | Last reply by Shamik Ghosh - Thursday, November 02, 2017 6:36 AM -
0 Votes
Using Tlog shipping to move data
I have a 2 node sql 2008r2 cluster with databases residing on equalogic storage. I am looking for the fastest way to move the data to compellent storage. Here is my thought ...Proposed | 2 Replies | 158 Views | Created by Kspencer66 - Monday, October 30, 2017 3:18 PM | Last reply by Kspencer66 - Monday, October 30, 2017 6:49 PM - Items 1 to 20 of 1977 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.
