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.
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky0VotesPlease 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. ...
-
Unanswered0VotesAdding drives to my RAID10 Logs partition
Hi, I have a Windows 2012 Failover Cluster with 2 nodes and 2 SQL 2012 Always-on Availability Groups. Both nodes are a physical machine and each node is the primary for an ... -
Answered0VotesSQL failover cluster Migration
Hi Team, I am having SQL failover cluster in my environment see the below structure, In my SQL failover I am having 2 Nodes Node 1:- Windows ... -
Answered0VotesException Handling In T SQL in SQL 2008
Hi I want to learn How to Handle Exceptions and Error In T SQL Statement in SQL server 2008 Please Explain How to Implement With simple Examples It is ... -
Answered0VotesSSMA 5.2 for Oracle O2SS0486 Error
First time using SSMA and I was hoping to get some help with an error I am seeing. I am working on a project to migrate a very old Oracle 8.0.5 database over to SQL Server ... -
Proposed2Voteshow to shrink transaction logs
i got a db that is 300mb but its transcation log is over 220gb. how do I shrink this file? -
Proposed0Votessqlcmd restore gives an error
sqlcmd -E -S SERVER -d "master" -n -b -Q "RESTORE D ATABASE SOPHOS50 FROM DISK = C:\SOPHOS50.bak WITH REPLACE, RECOVERY" Sqlcmd: Warning: '-n' ... -
Answered2VotesMigrating a x86 application to work with a x64 SQL Server 2005?
Hi, I have a SharePoint 2003 Portal server that is working with a x86 SQL Server 2000. I'm about to disconnect one of the SharePoint servers and create a new farm ... -
Answered0Votesmigrating sql server 2008 r2 cluster to a new cluster
Does anyone know of any good documentation and best practices for migrating to a new cluster? -
Answered0VotesTransaction Log Replay
Hi all, I am restoring a sql server backup for the first time as well as the most recent traction logs. I'm not having any problems with the backup/restore per se, just ... -
Unanswered0VotesMigrating SAP NetWeaver 7.30 ABAP and/or Java Databases from SQL 2008 to SQL 2012
We want to migrate some SAP NetWeaver 7.30 ABAP and some Java systems from SQL 2008 to SQL 2012. The question I have from a Microsoft SQL Server perspective is, is it just a matter of detaching ... -
Unanswered0VotesNo columns were returned from the database for table '...'
I'm migrating from a oracle 8.0.5.0 to a SQL 2008 R2. I'm connected to the oracle server, but when i select a table, it won't receive his ... -
Answered1VotesSSMA for Oracle (v 5.2) Exstention Pack Installation Error
Hi, We have run into an issue installing the SSMA for Oracle Extension Pack on the instance with Collation as case ... -
Answered1VotesUpgrading from SQL 2008 to SQL 2012 - Changing database file paths to \MSSQL11.{InstanceName}\MSSQL\DATA\{DBName}.mdf
I am doing an inplace upgrade of SQL 2008 to SQL 2012. The inplace upgrade leaves the database files to the same directory structure as SQL 2008. Example : ... -
Answered0VotesRegistering Microsoft.ACE.OLEDB.12.0' provider
Good day, i tried to import an excel data into my database and its telling me Microsoft.ACE.OLEDB.12.0' provider is not registered on your local machine. I tried installing AccessDatabaseEngine, ... -
Unanswered0VotesDealing with problem data: Skip, edit query, other options?
Migration > On Error set to "Proceed to next batch" and my batch size is the default of 10,000. I guess I could reduce the batch size but that still wouldn't give me all ... -
Unanswered0VotesDTS packages
is there any way to stop transformation task in middle?? we are doing some data dump task by using data transformation tasks in DTS. if any NULL value present in Data we need ... -
Answered1VotesMoving a SQL 2012 database to SQL 2008 R2
We did an upgrade from SQL 2005 to SQL 2012 a week and now we are finding that one of our software vendors does not support SQL 2012 and we are running into some problems with the application not ... -
Answered0VotesSQL server 2008 standard edition supported processor
i want to install sql server 2008 r2 standard edition But the server in Intel Xeon E5-2620 6 core processor. i want to know the sql server standard edition does support it...? i check in all ... -
Answered0VotesThe rights of the login for that database are not copying....any way to do it also automatic?
When I am migrating my logins from one instance to other using sp_help_revlogin then the rights of the login for that database are not copying....any way to do it also ... -
Answered0VotesMysql migration
What is the driver used to migrate the database from sql to mysql in windows platform. - Items 1 to 20 of 869 Next ›


