View Complete Post
import/export wizard in 2000 had lots of options.
I could copy databases without a care in the world. Including constraints, stored proc., AND the data, etc.
Now, with v2008, the wizard is dumbed down too much. It's a "stupid" copy function that fails on the first constraint it meets.
"Copy database.." is not an option here: it needs sysadmin on both source and destination server.
Re-adding the constraints manually is not an option either: the database is WAY too large.
I'm actually hoping there is a temporary bug in the import/export wizard. Each option (and you have THREE...) returns with a new error.
Googling, I found I am not alone:
This post is exactly my situation. Here's what his post says: (bolded key parts)
"Hi I'm trying to get used to sql server 2008 having been
forced to upgrade by my isp. I need to back up my key db on a weekly
remote schedule, so have been trying to use ssms to export data from my
remote db to a local copy. Firstly I created a new empty db on
the local machine. Then I scripted the structure of the db on the
remote machine and ran the resulting query on the local machin
Let's start a very intresting thread here:
As you all know moving the database from one server(2000, 2005, 2008) to (2000, 20005, 20008) is not a big deal and can be done in many ways like backup-restore, attcah-detach, and most easy (some time very complex:-)).
Here i wanna discuss an issue which i have faced.
I have two instances of SQL server 2008, i have created a new database Test in one instance, created few logins and mapped to Test database with some permissions for this Test database.
Now i used copy database wizard to copy this test database to other instance, i sucessfully went through the wizard and selected SQL server object method to copy the Test database in other instance then i followed the remaing wizard, i selected the logins which i have created for the Test database and finnaly i reached the finish button i clicked finished and the copy of database completed sucessfully. I verified that Test dabase was there in other instance with the logins which i have created. So easy i was happy:-)
Problem: Some other day i wanted to copy AdventureWork database to the other instance of SQl server i was happy that its a very easy task i followed the same steps above(to copy the Test database ) and every thing went in the same way and i clicked finish to complete the wizard it took some time
Some blog posts out there show an option for bubble color in the map wizard. Currently I only see an option for size.
Is this something that didn't make it out of beta?
Sql Server 2008 import and export wizard is failing with the message: \
The ‘DbProviderFactories’ section can only appear once per config file. (System.Configuration)
This wizard will close because it encountered the following error: (Microsoft SQL Server)
This happens when I hit the “Next” button on the initial import/export wizard startup screen.
The detailed error message is below.
Any ideas on the location of the configuration file that the change needs to be made to?
I have been getting "Unexpected Unrecoverable Error; Abort, Retry, Ignore" when using the SQL Import/Export Wizard in the following scenarios (these are the only two ways I have tried using the Wizard):
1) Source Advantage OLE DB Provider, destination SQL Server, copy tables
2) Source Microsoft Excel, destination SQL Server, copy tables, show report if there were any failures
I have run the SQL Setup Repair and still get the same behavior. Are there known issues with SQL Express 2008 R2 on Windows 7 for Import/Export?