New answers tagged

1

If you migrate from RDBMS to NoSQL then you will also have problems. They are not interchangeable for all types of usage. When you start a project then just before you start the creation of your data objects you must choose the one that suits best to your needs. Changing later will nearly always cause problems as soon as you use more then the 'standard' ...


0

Yes you can. Use SQL synonyms https://msdn.microsoft.com/en-us/library/ms187552(v=sql.105).aspx By doing that you'll have a full control behind the curtains, but please fully document it and be consistent. It is a nightmare to troubleshoot databases with synonyms. As an alternative you can use dynamic SQL, it might be more transparent.


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 ...


0

You need to restart mysql to see the changes you made. Go to Task manager and click services tab. In the services tab, you can find mysql to restart..


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 ...


0

I came around looking for a solution to export an IMAGE Column having stored different kind of file types (pdf, xls, doc, xml ...) I want to export. The approach in the answer worked for pdf files only. To export all kinds of files I had to adjust the solution as follows: (1.) Create a format template file: Declare @sql varchar(500); Declare @sql varchar(...


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 ...


0

Any specific reason to migrate to MySQL? https://wordpress.org/plugins/postgresql-for-wordpress/ Else MySQL Workbench will work. You'll always have to take into consideration any functions/triggers, etc. that might contain advanced pgsql syntax, etc. http://mysqlworkbench.org/2012/11/how-to-migrate-postgresql-databases-to-mysql-using-the-mysql-workbench-...


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 ...


0

I used Oracle datapump expdp/impdp. On the source database using expdp: SQL*PLUS: CREATE USER username IDENTIFIED BY pw; GRANT dba TO username; CREATE DIRECTORY db_copy AS ‘E:\DB_copy’; GRANT read, write ON DIRECTORY db_copy TO username; CMD: expdp username/pw DIRECTORY= db_copy DUMPFILE=filename_%u.dmp filesize=5gb FULL=Yes METRICS=Y EXCLUDE=STATISTICS ...


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 ...


0

MySQL Workbench provides a quick way to migrate data and applications from Microsoft SQL Server to MySQL with fastest possible ways utilizing resources.20 GB data is not a big deal.There are tools available in the market but which is not free of cost.


0

Maybe you can use CHARINDEX casting your Address1 to varbinary(8000) to identify the offending data: select * from [ForgeDB].[Snapshot].[SnapshotPersonEmployee] where charindex(0xA0, cast(Address1 as varbinary(8000))) > 0; Check this answer: http://dba.stackexchange.com/a/37355/55596


0

Hex A0 probably came from a Word document, where it is a "hard space". It appears that you did not specify that the source was 'latin1' and the destination is 'utf8'. Otherwise, A0 should have turned into C2A0. That seems correct. However, this seems incorrect: "Driver sends Unicode data as UTF-8". Or perhaps just inconsistent with "Collation ...



Top 50 recent answers are included