Computers & Internet Logo

Related Topics:

Sagesh Koodathil Posted on Jan 23, 2008

SQL Server Data Export

Hi ,
I want to export data from one database to another database.In destination database there is no table(it will automatically create when I am importing).I want create the table with it's all constraints in destination db when i am doing a import.Now it's creating only the structure not constraints like primary key, default value etc.

Please advice

Thanks in advance
Sagesh.K

1 Answer

Anonymous

Level 1:

An expert who has achieved level 1.

Mayor:

An expert whose answer got voted for 2 times.

  • Contributor 3 Answers
  • Posted on Feb 01, 2008
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

Mayor:

An expert whose answer got voted for 2 times.

Joined: Jan 29, 2008
Answers
3
Questions
0
Helped
1059
Points
8

The best way to handle this situation is to generate a script of the database objects and then run it on the remote server before exporting the data.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
3answers

How to recover SQL Server Database file formate?

After you connect to the appropriate instance of the SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree. Tweakbox How To Use
1helpful
6answers

Repair a corrupt SQL database in SQL 2005

Known as the leading solution provider in the field of data recovery and data conversions, the company has created a niche for another efficient tool known as SQL Server Repair Toolbox. The MS SQL repair tool reads *.mdf and *.ndf files and saves data, structure, links, etc. as SQL scripts or exports directly to Microsoft SQL Server through direct connect. read more details SQL Server Repair Toolbox
0helpful
1answer

How to convert sdf file in xls file ?

SDF file is a compact relational database also called a SQL server database. Designed for the application that runs on mobile devices and desktop.
If you only want to access SDF files in Excel sheets then you can see your SDF files in SQL Server or Visual Studio.
0helpful
1answer

How to place MySQL database on host

my sql data can be transfered using the export options within mySQL.

# mysqldump -u username -ppassword database_name > FILE.sql

http://www.clockwatchers.com/mysql_dump.html

goto Cpanel of the remote host and
select import and select a the file with the table contents & data.

Regards
GeWiz.
0helpful
1answer

How to export table in ms access to excel

yes you can export your access data into excel, follow steps on how to export.

1. open your access database
2. open the table data you to export
3. under table data view click tools menu
4. select analyze
5. select ms excel
6. this will open your seleted access table in excel

hope this will help you..

0helpful
4answers

Restoring files from the database

I suggest you use the Enterprise manager (gui tool to manage SQL).
Restoring a single table is not an option.
You can however restore a file or filegroup.
Make sure to backup before you start and NOT to restore database to its original name or original file location, to avoid acidents.
Normally you will have databases with only 2 files: the data at its Primary file group, and log file.
You may wish to create a new file group and move tables to the new group by recreating them there and exporting data from old table to new table. Then recreate indexes. This may prove to be complex as all tables and indexes have unique names and can't coexist with exact duplicate of them.

oh yea..... did I say backup?
well just in case backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup backup
but dont overwrite that backup
Not finding what you are looking for?

162 views

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

Brad Brown

Level 3 Expert

19187 Answers

Cindy Wells

Level 3 Expert

6688 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...