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 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 | 34261 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
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 | 8 Replies | 1185 Views | Created by sk_786 - Monday, December 2, 2019 9:20 PM | Last reply by Alexander-Ivanov - Monday, December 23, 2019 8:54 PM -
0 Votes
How to export a specific user from MS sql 2000 and import to 2008
I have use the backup function MS sql 2000 and then restore it at 2008 , it seems all data and most of user are migrated to 2008 , however , I found a user with simple password can not be restored , I ...Unanswered | 4 Replies | 647 Views | Created by patrick chan 701 - Monday, December 16, 2019 8:36 AM | Last reply by Cathy Ji - Thursday, December 19, 2019 9:35 AM -
0 Votes
move a user from MSSQL 2000 to MSSQL 2008
I have asked a below question , but I would like further ask the question ...Unanswered | 1 Replies | 456 Views | Created by patrick chan 701 - Wednesday, December 18, 2019 3:06 PM | Last reply by Dawn Yang - Thursday, December 19, 2019 7:42 AM -
1 Votes
In Migrating from a simple MS Access table to Azure I get Invalid object name sys.server_principals
Hi, I've been asked to migrate an Access db from Access 2010 to SQL on Azure. Starting small, I created a simple Name and Address Table in Access2010 in an accdb file. Then I created a db in azure so ...Unanswered | 5 Replies | 1503 Views | Created by WillAutio - Wednesday, July 3, 2019 4:53 AM | Last reply by Warren M - Wednesday, December 18, 2019 9:32 PM -
0 Votes
Rename MS SQL Server 2016
Hi there, We have an MS SQL Server 2016 enterprise edition installed with an instance. it's used by McAfee ePolicy Orchestrator. both are installed on seperate machines and joined ...Answered | 1 Replies | 351 Views | Created by gao_lei - Wednesday, December 18, 2019 3:54 AM | Last reply by Dawn Yang - Wednesday, December 18, 2019 6:42 AM -
0 Votes
Error building DAC package file in SSMS v 18.4
I get this error Could not extract package from specified database an error occurred while attempting to reverse engineer elements of ...Proposed | 5 Replies | 829 Views | Created by Brian Kim Petersen - Friday, December 13, 2019 7:35 AM | Last reply by Cris Zhan - Wednesday, December 18, 2019 1:42 AM -
0 Votes
Migration from SQL COMPACT To SQL SERVER
Hi All, I am migrating database from sql compact to sql server. During the migration process in copying database phase, the migration fails stating Execution Timeout ...Unanswered | 0 Replies | 423 Views | Created by Jinal Prajapati - Tuesday, December 17, 2019 2:34 PM -
0 Votes
Error Creating assembly from third party applications
When running a search request from a third party application we are presented with the following error: Error Loading Grid General ODBC Error An error occured in the Microsoft .Net ...Unanswered | 5 Replies | 840 Views | Created by BenjaminIT - Tuesday, December 10, 2019 9:48 AM | Last reply by Amelia Gu - Friday, December 13, 2019 8:18 AM -
0 Votes
Use JDBC instead of ODBC or OLE DB to connect to Sybase
In order to migrate Sybase server to MSQL server is it possible to connect to Sybase source using jdbc instead of using ODBC or OLE DB. Anyone who has tried this ...Proposed | 1 Replies | 484 Views | Created by SQL DBA - Thursday, December 12, 2019 8:08 PM | Last reply by Cris Zhan - Friday, December 13, 2019 7:02 AM -
0 Votes
Can not migrate SQL server 2000 user to SQL 2008 express
I have a windows server 2000 , there is a user with simple password . I have setup a SQL 2008 express , use backup and restore method to migrate data from 2000 to 2008 ...Proposed | 3 Replies | 734 Views | Created by patrick chan 701 - Thursday, December 12, 2019 9:50 AM | Last reply by Amelia Gu - Friday, December 13, 2019 5:21 AM -
0 Votes
SQL 2008 R2 sp3 and SQL 2008 sp4 , which one is newer
I just found there is version SQL 2008 R2 sp3 and SQL 2008 sp4 , but no SQL 2008 R2 sp4 , I think the newer one should be better to use , right ? May I know which one of version ...Unanswered | 3 Replies | 730 Views | Created by patrick chan 701 - Wednesday, December 11, 2019 4:06 AM | Last reply by Cris Zhan - Thursday, December 12, 2019 6:59 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 | 4 Replies | 1322 Views | Created by juniorkiran - Friday, November 22, 2019 3:14 PM | Last reply by Olaf Helper - Thursday, December 12, 2019 5:17 AM -
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 ...Answered | 5 Replies | 1124 Views | Created by iGBobH - Thursday, December 5, 2019 4:21 PM | Last reply by iGBobH - Wednesday, December 11, 2019 6:06 PM -
0 Votes
Migration from 2012 to 2017
Hi, I am new to sql server but a client of mine needs upgrading 2012 to 2017. I get that he would be getting the 2017 MS version but how do you upgrade the code ...Proposed | 3 Replies | 779 Views | Created by Vwgolg2013 - Tuesday, December 10, 2019 11:14 AM | Last reply by muthukkumaran kaliyamoorthy - Wednesday, December 11, 2019 12:27 PM -
0 Votes
Jbase to SQL server migration
Hi Team, Has anyone achieved JBase database to SQL server ...Unanswered | 2 Replies | 1077 Views | Created by ArunKumarJ - Tuesday, December 10, 2019 8:17 AM | Last reply by Cathy Ji - Wednesday, December 11, 2019 6:47 AM -
0 Votes
Migrate SQL 2000 to higher version
I have a windows server 2008 , which running MS SQL server 2000 , IIS , ASP , it is web server . As I am not sure if the ASP application can be run on the new version of windows ...Proposed | 3 Replies | 917 Views | Created by Derek Chan 456 - Monday, December 9, 2019 3:11 PM | Last reply by Cathy Ji - Tuesday, December 10, 2019 7:12 AM -
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 | 12745 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
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 | 1451 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 | 1148 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 | 1479 Views | Created by Brauprinz - Tuesday, November 26, 2019 1:10 PM | Last reply by Dedmon Dai - Wednesday, November 27, 2019 7:31 AM - Items 1 to 20 of 2329 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.
