Data Masking Software Resources

Articles, Glossary Terms, Discussions, and Reports to expand your knowledge on Data Masking Software

Resource pages are designed to give you a cross-section of information we have on specific categories. You'll find articles from our experts, feature definitions, discussions from users like you, and reports from industry data.

Contents

Data Masking Software Articles

What is Data Masking? Everything You Need to Know

Businesses are constantly entrusted with sensitive customer information, such as financial and biometric information, and with personal data comes great responsibility to ensure privacy and confidentiality.

by Alyssa Towns

Data Masking Software Glossary Terms

Data Subjects

A data subject is an individual who can be identified by specific pieces of data. Learn more about the types, elements, and best practices under GDPR.

by Holly Landis

Data Masking

Data masking allows organizations to share data safely. Learn what it is, what types there are, and how to use it.

by Martha Kendall Custard

Data Masking Software Discussions

Question on: Microsoft SQL Server

how did you import a MySQL database?

I need to import a MySQL database but I can't.

Show Less

You can use the LinkedServer feature to mySQL database using the provider. Check here for further details. https://www.mssqltips.com/sqlservertip/4570/access-mysql-data-from-sql-server-via-a-linked-server/

Show Less

Answered: Lambolla Mariano on November 27, 2019

Try this: https://www.sqlshack.com/migrate-mysql-tables-sql-server-using-sql-server-migration-assistant-ssma-ssis/

Show Less

Answered: Derek Curtis on December 5, 2019

You can indeed use the Sqlserver migration assistant. But you might run into problems later on because of collation settings. I prefer to create the datamodel myself in Sqlserver. I then have total control of the type of fields I want to use to optimize the data as good as it can be. After that, I rebuilt the code in the SQL server that is present in MySQL. Use a linked server connection to MySQL to get the data into Sqlserver. TSQL and Sqlserver has more features than Mysql to improve performance. You do not want to missout on that one. It is less fun to walk with a horse and carriage on a racetrack. Cheers

Show Less

Answered: Michel Sliwa on December 5, 2019

See more answers (2)

Your answer

Question on: Microsoft SQL Server

How can I work on the same query if the connection is lost (timeout) and then I reconnect?

When I let the SQL session expire, I try to reconnect again and use the same query file I was working on, but it doesn't let me continue because it's says that I'm not connected to any database. So I have to restart the application, connect again and then the query will work.

Show Less

When this happens to me in SQL Server Management Studio, I just have to type USE {your database name here} and then select only that statement and execute it. This re-establishes my connection and I can continue to work on my query.

Show Less

Answered: Jonathon English on October 10, 2019

change the timeout of the query; right click a-> server => select properties -> Remote server connections => remote query timeout field. Give a big number there

Show Less

Answered: Abhishek Gogineni on November 15, 2019

Depends what you are doing. If you ran a stored procedure than it will finish but that also depends how you coded transaction handling in the stored procedure. If you are just doing a simple select of an insert and the connection is broken. Then Sqlserver will rollback in case of an insert. A simple select will be terminated. If you want to guarantee the fact that you want to be able to work on after a connection loss then you should transfer your SQL into a stored procedure and in that stored procedure you program that the next time the stored procedure is executed ( after a connection loss) that it will continue the job it was doing by looking into a status table where it can pick up were it left.

Show Less

Answered: Michel Sliwa on December 5, 2019

You can change the timeout for the query: In the object explorer, right click a server and select properties. Go to Remote server connections, look for the remote query timeout field; then type or choose a value from 0 to 2,147,483,647 to establish the maximum number secs that SQL Server will wait before timing out

Show Less

Answered: Sergio Antonio Enríquez Gabino on October 2, 2019

See more answers (3)

Your answer

Question on: Microsoft SQL Server

Best features in SQL

Other features in SQL?

Show Less

It has all DBMS manipulation commands and techniques for implementation

Show Less

Answered: Piyush Jaisinghani on November 28, 2021

There is no best future in SQL, There are only different futures per platform. If you are using PLSQL or TSQL then you can distinguish futures because of the fact that one database engine will treat the data processing differently than the other and you can influence that in different ways. That is the best future per platform.

Data Masking Software Resources

Articles, Glossary Terms, Discussions, and Reports to expand your knowledge on Data Masking Software

Data Masking Software Articles

What is Data Masking? Everything You Need to Know

Data Masking Software Glossary Terms

Data Masking Software Discussions

Data Masking Software Reports