September 15, 2010 at 5:19 am
Hi All,
I have situation. I have some rows in the sql server 2005 database table, need to be move from test system to prod.
Is there any way to generate a script for insert commands for rows?
Thanks in adanvce.
Ravi
September 15, 2010 at 6:02 am
how many rows are there? I use SSMSToolsPack add on to SSMS. I found that it is slow once the rowcounts start exceeding 1000 rows. It's a free download at http://www.ssmstoolspack.com/
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 15, 2010 at 6:56 am
-If you have BIDS you can just create a new integration server project and compose the stuff you want to using the import/export wizard.
-You could also just use SQLCMD to export the data to a file in e.g. csv format, move the file to your prod server and import the data using SQLCMD with a bulk insert statement.
- With SSMS you can also script the data of your table to a script and execute that script on your prod box
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 15, 2010 at 9:18 am
Thanks. you made my day mate!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply