Restore SQL Database DATA ONLY

Question

I have two databases with exactly the same schema. I want to export data from one and replicate it on the other. I don't wish to drop and recreate tables, just zap all the data in the target db and replace it with the data exported from the source database.

I assume this is possible? The target database is on a client environment with very limited permissions.

Answer 1

You can use SQL Server Import and Export Wizard to import the data. The SQL Server Import and Export Wizard can copy data to and from database.