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 |
|
feejaz
Yak Posting Veteran
68 Posts |
 Posted - 2008-07-26 : 00:49:30
|
| Hi,I have created the database with tables and enter some data in it. Now i want to get the script to another machine. I does not want to use mdf or ldf file.I have generated the script but it only get the table structure not the data.Can any one tell me how can we get the script of table with its data.ThanksNavi |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-07-26 : 01:54:55
|
| Use the Import/Export Wizard. right click on database -> Tasks -> Export data (if you are on source else Import data from target)Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
feejaz
Yak Posting Veteran
68 Posts |
Posted - 2008-07-26 : 02:00:23
|
| thanks for repling,I am using sql server express 2005.I could not found the export/import in itNavi |
|
|
|
feejaz
Yak Posting Veteran
68 Posts |
Posted - 2008-07-26 : 04:33:12
|
| I have not found any script which will fullfill my requirement.I want to script which will get all the table with its record.I want to use this script on the remote server therefore i could not use the mdf filesNavi |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-26 : 09:21:02
|
| Then backup databse and restore in remote server. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-07-26 : 12:12:08
|
| Our Mladen from SQL Team has a tool that might be helpful: http://www.ssmstoolspack.comDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-28 : 00:02:41
|
quote:
Originally posted by feejaz
thanks for repling,I am using sql server express 2005.I could not found the export/import in itNavi
you can install it if you wanthttp://mobiledeveloper.wordpress.com/2007/01/31/data-import-export-with-sql-server-express-using-dts-wizard/ |
|
|
|
feejaz
Yak Posting Veteran
68 Posts |
Posted - 2008-07-28 : 05:07:33
|
| I only just want to know that Is it possible in SqlExpress 2005 to create table scripr with its records(data), like we can do in the sqlserver 2000.Navi |
|
|
|
|
|
|
copy table with data Sql server 2005