SQL server export/import?

Question

hello!

i am trying to export all the data and tables of one remote sql database to another remote sql database...

how do i do that?
I tried to search on online but no luck...(please dont tell me to Google it,lol..)

Thanks in advance

This is sql server not mysql !

they are in different servers..php my admin not possible

i am looking for some solution in the sql server 2005 itself....

Answer 1

It depends on the Version of SQL Server you are using.

If you are using SQL Server 2000, you can accomplish what you need by using Data Transformation Services (DTS). You can use wizards from enterprise manager to import/export database data and objects.
http://msdn2.microsoft.com/en-us/library/ms141209.aspx

In SQL Server 2005, DTS has been replaced with SQL Server Integration Services (SSIS)
http://www.databasejournal.com/features/mssql/article.php/3580216

Answer 2

Each server functions differently how exporting and importing is done but most involves command line work, I know for sure MySQL can just switch to XML output while reading a plain text batch input. DB2 do it differently, SQL Server probably different again.

But command line is one commonality, however what is wrong constructing an ODBC/JDBC/ADO/whatever SQL shell and doing the samething by select *?

Answer 3

If you only wish to export the data once, then use SQL Backup and Restore. The trick is to redirect the destination to the remote server during he Restore process.

If you wish to keep the remote server up to date on a periodic basis, I recommend Replication or log shipping. SQL Books Online shows how to set up replication.

Answer 4

go to http://www.mysql.com/products/tools/administrator/

Scroll down and look on the bottom left side of the page... You will see "Download Binaries & Source" Click that.. Get the mysql administrator... Great program.. It will do anything you want it to do with sql

Answer 5

Go to phpmyadmin from your control panel, there you will find options export, import