Question about Computers & Internet

1 Answer

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

Posted by on

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 3 Answers

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.

Posted on Feb 01, 2008

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

5 Answers

How do I recover data from .mdf file


Detach you database. Overwrite the mdf and ldf files you've restored from your backup with your files from the D: drive. Reattach the database.
There is no guarantee that this will work or if it works, that your database is in a state where you can continue to work with.
If that doesn't work then there is an option to try to restore database using SQL Server Recovery Toolbox. It is a powerful tool for data recovery. They have a demo version. So you can check it works in your situation or not.
http://www.oemailrecovery.com/sql_repair.html

Jan 19, 2016 | Microsoft SQL Server 2008 Enterprise Full...

7 Answers

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

Jun 13, 2015 | Microsoft SQL Server 2005 Enterprise...

5 Answers

Some requirement for SQL server repair


Read this blog at the following link: http://recoverymaster.livejournal.com and know helpful details about MS SQL server database recovery wizard. You can download this software: http://www.sqlrecovery.org

Jun 10, 2014 | Microsoft Database Software A5K-02817 SQL...

16 Answers

How can I repair a corrupted MDF files and SQL server?


Similar question has been answered here: http://www.fixya.com/support/t24364927-sql_repair_recovery_process_very

Before asking any question in the forum, first you need to search your problem.

May 12, 2014 | Microsoft Database Software A5K-02817 SQL...

1 Answer

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.

Jun 15, 2009 | The PHP Group PHP

1 Answer

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..

Dec 13, 2008 | Microsoft Access 2002 for PC

4 Answers

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

Feb 11, 2008 | Microsoft SQL Server 2000 Standard Edition...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

125 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

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

Answer questions

Manuals & User Guides

Loading...