Exporting one database to another database

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008R2

I have got 2 databases. The two databases have same tables and same structure. I need to export data from one database another database both database have a data only insert distinct data using procedure or ssis pakage
Thanks
Abhishek

Posted 9-Jul-14 0:03am

Member 10918284

Add a Solution

Comments

[no name] 9-Jul-14 7:34am

Okay.... and? Did you have some sort of a question? Have you actually tried anything? What was the specific problem with what you tried?

nayeem@codeproject 21-Jul-14 5:34am

hiiii

Right click on database which you want to export----> tasks--->export data--->next--->select datasource,server name & database name which you want to export --->next--->select Destination where you want to store,server name & database name--->next---->check the option copy data from one or more tables or views---->next--->select all to export database--->check save SSIS package
--->next----> give name --->next--->finish---->close

this is all about export

To import

Right click on database which you want to import----> tasks--->import data--->next--->select datasource,server name & database name which you want to import --->next--->select Destination where you want to store,server name & database namename--->next---->check the option copy data from one or more tables or views---->next--->select all to import database--->check save SSIS package--->next----> give name --->next--->finish---->close

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

nayeem@codeproject · Answer 1 · 2014-07-20T23:35:00

SQL

hiiii


Right click on database which you want to export----> tasks--->export data--->next--->select datasource,server name & database name which you want to export --->next--->select Destination where you want to store,server name & database name--->next---->check the option copy data from one or more tables or views---->next--->select all to export database--->check save SSIS package
--->next----> give name --->next--->finish---->close

this is all about export

To import

Right click on database which you want to import----> tasks--->import data--->next--->select datasource,server name & database name which you want to import --->next--->select Destination where you want to store,server name & database namename--->next---->check the option copy data from one or more tables or views---->next--->select all to import database--->check save SSIS package--->next----> give name --->next--->finish---->close

mcdubey · Answer 2 · 2014-07-22T03:48:00

SQL

use <DestinationDatabase>
select * into <DestinationTable> from <SourceDataBase>.dbo.<SourceTable>

1 - Right click on the database you want to copy

Choose 'Tasks' > 'Generate scripts'

'Select specific database objects'

Check 'Tables'

Mark 'Save to new query window'

Click 'Advanced'

Set 'Types of data to script' to 'Schema and data'

Next, Next

You can now run the generated query on the new database.

Option 2

Right click on the database you want to copy

'Tasks' > 'Export Data'

Next, Next

Choose the database to copy the tables to

Mark 'Copy data from one or more tables or views'

Choose the tables you want to copy

Finish

Exporting one database to another database

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0