Hot answers tagged

3

In your case you could not use transportable tablespace because the source database have to be Enterprise edition. In general, I would prefer upgrade using rman. But in your case it is not so easy because direct upgrade from 10.2.0.4 to 12.1.0.2 is not supported. You would have to upgrade to intermediate release (e.g. 10.2.0.5) that can be directly upgraded ...


3

I understand this is an old thread, but it was the first hit when I searched "how to move mdw database" on Google. I had configured MDW (Data Collection) on a SQL Server 2008 R2 production server, and I hosted the MDW database in a QA instance. Later on I had to move the QA instance to a different machine, with a different name (migration and name change ...


2

How familiar are you with Informix? MySQL? Unix tools (like Perl, Python, etc)? You can get the database schema and the data in Informix's UNLOAD format using Informix's DB-Export (dbexport) command: dbexport dbname This will give you a directory dbname.exp containing a file dbname.sql with the schema, and a bunch of unloaded data files such as ...


1

Finally worked after changing the database owner. The database was reattached by a different user so the owner was something else. use [database name]; exec sp_changedbowner @loginame = 'loginX'; After that the user loginX was able to access the database. It still does not show under Security -> Users but the database is mapped for the loginX login on ...


1

Any uninstall of SQL Server will not delete the data or log directories used by the particular version. The reason your data and log files stayed in the same spot is because you did an inplace upgrade. It will not move the databases to the "new" folders SQL Server 2012 would create (eg. "..\MSSQL11.MSSQLSERVER\DATA"). The only issue you could hit when ...


1

Just because a file is names ".RDA" does not guarantee it is Oracle. It could be Oracle, but then it would/should come with a whole infrastructure, not just a datafile. And if it is Oracle, then you'll need Oracle to get the data out. You may be able to use the EXPRESS EDITION depending on how official this is. You need to speak to the 'owner' of the RDA ...



Only top voted, non community-wiki answers of a minimum length are eligible