Question about Compilers & Programming Tools

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

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert whose answer got voted for 2 times.

  • Contributor
  • 3 Answers
Re: SQL Server Data Export

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

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

4 Answers

Some requirement for SQL server repair

Read this blog at the following link: and know helpful details about MS SQL server database recovery wizard. You can download this software:

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

3 Answers

How to Repair Corrupted MS SQL Database (MDF) File?

To choose a reliable and 100% safe and secure, a Microsoft SQL server database recovery program guarantee the zero loss of quality. You can see this page:
See demo:

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

14 Answers

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

Similar question has been answered here:

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

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

5 Answers

Need Help to backup SQL database in safe mode

kindly choose the option safe mode with networking and then try.

Sep 10, 2009 | Microsoft Compilers & Programming Tools

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

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


Jun 15, 2009 | The PHP Group PHP

Not finding what you are looking for?
Compilers & Programming Tools Logo

Related Topics:

122 people viewed this question

Ask a Question

Usually answered in minutes!

Top Compilers & Programming Tools Experts

Robin Hill
Robin Hill

Level 3 Expert

1246 Answers


Level 3 Expert

18257 Answers


Level 3 Expert

733 Answers

Are you a Compiler and Programming Tool Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides