database migration assistant - DB with Multiple files
-
Hello,
Re : Migration SQL Server database using DMA
In DMA UI, we have option to specify one location to restore the data files on target server. There is no option to restore DATA files of a database to multiple directories.Is there any way we can restore database with multiple data files to different directories using DMA?
-
If i recall correctly DMA is not used to migrate the database per se, its used to collect the prerequisites you need to migrate from one version to another, it doesn't do the migration it self, it just gives you tips if you can or not do the migration from one version to another..
Example.
-Use explicit joins and not where clause to do the joins
-Use datatype X instead of X in this table
-Function X is gonna be removed in future version
-
New version of DMA can migrate on-premises SQL Server instance to a modern SQL Server instance hosted on-premises or on an Azure Virtual Machine. DMA can be called from cmd line also.May be some addition parameter can do the trick.Not sure.Looking for some guidance
-
Nice, i didn't knew it.
I was testing with adventure works, it lets you choose multiple directories for your database, depending on how many data files there are after the validations it lets you manually to point where you want them restored.
Here's an screenshot.
Note: the error message is because it automatically chose the same name of the database AdventureWorks2016, i changed it to AdventureWorksDMA.
Greetings.
-
Thanks.So we cannot overwrite a DB which already exists in target with same name?
-
Any suggestions?
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply