Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Boody
Starting Member
4 Posts |
 Posted - 2013-08-29 : 23:25:07
|
I want to export my shipping from one onlineshop (prestashop) to my new onlineshop.Is it possible to export the files in the attachment and import them to the new database?If this is possible do I need to run a query after I import?Thanks : |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-29 : 23:48:56
|
| yep..you can detach the database and send the mdf,ldf and ndf(if any) files as attachment. then in new server download and attach themEither attach/detach using Management Studio UI or use sp_detach_db and sp_attach_db procedureshttp://technet.microsoft.com/en-us/library/ms188031.aspxhttp://technet.microsoft.com/en-us/library/ms179877.aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-29 : 23:50:15
|
| If you just want to export data alone use Export Import wizard from SQL management studio. I hope both your databases are in same domain------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Boody
Starting Member
4 Posts |
Posted - 2013-08-29 : 23:58:10
|
quote:
Originally posted by visakh16
If you just want to export data alone use Export Import wizard from SQL management studio. I hope both your databases are in same domain------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Thank you for your response. I do not have any sql experience so I am hoping it can be done with limited sql abilities.The shipping table that I want to export is on a different server to where I need to import it to.I had to manually input the weight and prices for about 100 countries into my store and have now made a new store (different product) and want to use the same shipping table.It would be great if there was an easy way to do this. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-30 : 00:29:11
|
quote:
Originally posted by Boody
quote:
Originally posted by visakh16
If you just want to export data alone use Export Import wizard from SQL management studio. I hope both your databases are in same domain------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Thank you for your response. I do not have any sql experience so I am hoping it can be done with limited sql abilities.The shipping table that I want to export is on a different server to where I need to import it to.I had to manually input the weight and prices for about 100 countries into my store and have now made a new store (different product) and want to use the same shipping table.It would be great if there was an easy way to do this.
see step by step article on export import wizardhttp://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Boody
Starting Member
4 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-30 : 03:01:39
|
| what do you mean by "sql in my xampp folder"?do you mean .sql files stored in folder or do you mean database itself?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Boody
Starting Member
4 Posts |
Posted - 2013-08-30 : 04:00:19
|
quote:
Originally posted by visakh16
what do you mean by "sql in my xampp folder"?do you mean .sql files stored in folder or do you mean database itself?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
HiSorry for the confusion. From PHPMyAdmin in xampp to PHPMyAdmin in my cpanel for my live website.The local website in xampp has a different domain than the live website that I want to import into. |
|
|
|
|
|
|
Export and Import Database