| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-08-15 : 22:14:59
|
| melthemel writes "guys,is it possible to generate SQL script for tables to include data? is there a way to do this with out coding or creating an app, just using Enterprise Manager or other similar stuff? i got a problem whenever i'm updating our app. production data is running and i need to add some configuration tags and values. i'm using MS SQL 2000 by the way. tnxs guys." |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-15 : 22:42:49
|
| You can use the SQL Compare product for this. I have used it for just this purpose and it seems to work very well.Alternatively, it can't be very hard to build a small app to do this yourself. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-16 : 00:14:20
|
| There are already scripts written for this. Here are a couple good resources:http://www.nigelrivett.net/http://www.sqlservercentral.comLook at the bcp in/out scripts and the DMO scripts to get what you need. Alternatively, you could buy a tool like SQL Compare.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-08-16 : 01:58:31
|
| SQLTeam veteran Chad has a product that does just that: www.clrsoft.comChad, do something about that site, please!OS |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-16 : 08:01:04
|
| Why are so many SQL Server related sites UGLY? :)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-08-16 : 08:42:43
|
Cause sql-server guys are GEEKS and no geeks know good design, that's just a fact of life (no offence people  )--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
Amethystium
Aged Yak Warrior
701 Posts |
Posted - 2004-08-16 : 10:09:18
|
I asked Nigel, (that's nr here) the same question ages ago and he said that he was more bothered about the contents of his website.. which is fair enough I suppose but..A good design makes the site more interesting... if only the SQL Server gosus spent more time learning some fancy software like Dream Weaver or even a simpler version like Jasc's Namo Web Editor (think they've sold it off now)...My 3-4 cents on this ------------->>> BREAKING NEWS!!! <<<------------- Saddam Hussien has weapons of mass destrcution |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-08-16 : 11:10:23
|
| Belive me, it's not DreamWeaver or Flash or Namo that create the cool websites just like it's not Query Analyzer that makes the ingenious sql-scripts. It's the guy that spends his life in front of the computer, and alot of people don't see this with cool looking websites. You gotta be a creative soul to pull off stuff like that and it's just something you gotta live with if you can't do it. Some people tend to use the left side of the brain others tend to use the right. --> http://www.2advanced.com--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-08-17 : 05:36:11
|
| I work with creative people that do the design stuff for the web sites that we build. I have absolutely no comprehension of how they know what looks right, but I do know that what they do looks great, and what I do looks [insert derogatory adjective of your choice]!Kristen |
|
|
|
|
how to generate SQL script for tables to include data