While there were several headline-grabbing ransomware attacks during in 2017, another big threat started appearing at the same time that didn’t get the same coverage – illicit cryptomining.
Problem exporting database from SQL Server 2005 to 2014
I am trying to export a database from a SQL Server 2005 to SQL Sever 2014
I use SQL Studio installed on the "2014" machine
The "2005" is on another (production) machine
In Studio, I connect to both server then on the 2005 item, I right click, select Export and fill in the fields.
Then GO, and I get this after a while
Login timeout expired
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Named Pipes Provider: Could not open a connection to SQL Server [2]. (Microsoft SQL Server Native Client 11.0)
I verified the configurations and both server have named pipes enabled
Whatelse shoudl I check ?
I use SQL Studio installed on the "2014" machine
The "2005" is on another (production) machine
In Studio, I connect to both server then on the 2005 item, I right click, select Export and fill in the fields.
Then GO, and I get this after a while
Login timeout expired
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Named Pipes Provider: Could not open a connection to SQL Server [2]. (Microsoft SQL Server Native Client 11.0)
I verified the configurations and both server have named pipes enabled
Whatelse shoudl I check ?
Asked:
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
I tried right now and it worked
I think that the problem comes from the fact that the server (running SQL Server 2014) refuses non-local connections.
But I don't know how to enable that
Running the SQL Server configuration manager, I see that all Client protocols are enabled.
But the items SQL Native client 11.0 configuration 32 bit and SQL Server Network Configuration 32 bits are "empty"
Maybe that's the problem but I don't know how to fix it
I think that the problem comes from the fact that the server (running SQL Server 2014) refuses non-local connections.
But I don't know how to enable that
Running the SQL Server configuration manager, I see that all Client protocols are enabled.
But the items SQL Native client 11.0 configuration 32 bit and SQL Server Network Configuration 32 bits are "empty"
Maybe that's the problem but I don't know how to fix it
You cannot export the database. The way to get SQL 2005 DB on to SQL Server 2014 is as follows:
1. Perform a backup of the database
2. Restore the backup on to SQL Server 2008
3. Go to properties, Options, change compatibility level SQL Server 2008
4. Backup the databases again and restore in SQL Server 2012
5. Change compatibility level to SQL Server 2012. Backup the database
5. Restore the database on SQL Server 2014. If you choose, you could change the compatibility to SQL Server 2014 or leave it at 2012
Below are some other options:
- Upgrade the older version of SQL Server to be at the same level as the newer SQL Server and this will allow you to either backup and restore or move the databased by attaching DB files
- Script out the objects from the newer database and then use a process to extract the data from the newer database and import it into the older database
- Build an SSIS package to move the data by using Import and Export Wizard (it will move the data only and database needs to be created on the target)
- Build a custom SSIS package to do the data move
- Use replication to move the data to the newer database from the older database
- Use some third party tools
1. Perform a backup of the database
2. Restore the backup on to SQL Server 2008
3. Go to properties, Options, change compatibility level SQL Server 2008
4. Backup the databases again and restore in SQL Server 2012
5. Change compatibility level to SQL Server 2012. Backup the database
5. Restore the database on SQL Server 2014. If you choose, you could change the compatibility to SQL Server 2014 or leave it at 2012
Below are some other options:
- Upgrade the older version of SQL Server to be at the same level as the newer SQL Server and this will allow you to either backup and restore or move the databased by attaching DB files
- Script out the objects from the newer database and then use a process to extract the data from the newer database and import it into the older database
- Build an SSIS package to move the data by using Import and Export Wizard (it will move the data only and database needs to be created on the target)
- Build a custom SSIS package to do the data move
- Use replication to move the data to the newer database from the older database
- Use some third party tools
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trialIt's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server
From novice to tech pro — start learning today.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get every solution instantly with Premium.
Start your 7-day free trial.