Import/Export

[Vandy02]

I am trying to import all data from a database called a into one called b. When I run the import wizard I copy all the tables and everything looks good. However, it did not copy the stored procedures over. Therefore, I run the wizard again, but running copy objects..I then get an error saying that an object already exists...basically I am trying to find the best way to copy a database. Is the best way using a backup and restore??

 

[JohnDTampaBay]

Backup and restore is one of the easiest and quickest methods, if you don't need to persist anything from the destination database. In the Import Wizard on the step titled Specify Table Copy or Query, only option 3 Copy objects and data between SQL Server databases gives you the ability to transfer stored procedures. Is this the option you chose?

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[ClaireHCM]

Sometimes Import wizard (Copy objects and data bwtween SQL Server databases) gives you the flexibility when the backup file is in remote site or over the network, or when you dont have permission to retrive the backup file. I usually uncheck all the option in security option to prevent that orphant user or role happening.