Re: SQL 2000 option in - Import Export Wizard - Copy objects and data between Sql Server Databases - not available in SQL 2012 express
Category: sql server express
SivaprakashBKR on Fri, 23 Jun 2017 11:43:41
SQL 2000 option, in Import Export wizard, not found in Sql 2012 express
Out of the 3 options,
- Copy table(s) and view(s) from the source database
- Use a query to specify the data to transfer
- copy objects and data between sql server databases.
the last one is not available in sql server 2012 express edition. Now I need to transfer the full data from one sql server database to a newly created sql server database.
Is there any solution to do it in sql server 2012 express ?
Lin Leng on Tue, 27 Jun 2017 06:41:58
>> the last one is not available in sql server 2012 express edition.
The last option is not available anymore. Could you please elaborate more on the requirement, does traditional backup/restore satisfies your requirement?
If you have any other questions, please let me know.
Hilary Cotter on Tue, 27 Jun 2017 12:25:46
It is still there - make your import source SQL Server and your destination SQL server. Note that views will be copied over as tables, so it is better to script them out and deploy them.
Note further that a backup and restore will likely be faster.
TiborK on Tue, 27 Jun 2017 12:29:26
"t is still there - make your import source SQL Server and your destination SQL server. "
But that won't pick up logins, users, indexes, triggers, constraints, procedures etc etc.