| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> jsp and php is generally best imho - server hosting in combination with myssql is pretty cheap
<1> voidzilah : using any web-based languages to work w/ SQL...is it a rough time ?
<2> It's not difficult to "just get it working" The real effort is in building it correctly.
<1> well you have to make SQL communicate w/ the gateway, right ?
<2> are you talking about a web-based db connected app?
<1> sorta - storefront
<2> web based
<2> with a db behind it
<1> yes, whats the point of it ?
<2> where is your server-side code sitting in relationship to your db?
<1> php
<0> CJB2K686, not really
<3> nope, never found a way to force a production db in to a standby mode
<0> u just need the connectors
<3> i dont think you can really, it might screw up how the LSN's work, i dunno
<3> Halo_Four you think it might be a db flag?
<0> by standby u mean offline?
<3> no, you can still access it in a read only mode
<0> ah
<0> then
<0> thats easy
<3> this outta be good.
<0> right click it, go to properties, options, readonly?
<3> hehe
<0> i do it from time to time in a production env
<0> when we upgrading software modules
<0> *shrug*
<0> Rizard?
<3> what?
<4> i'm looking for a different way to populate a database with a bunch of test data than to write a script with a bunch of inserts
<4> i can't just import a csv or xls because i want primary keys to be hooked up and stuff (so right now i'm doing set @blahID = scope_identity() )
<5> you can import from csv or whatever as long as you (a) ensure the keys match and (b) import them in the right order
<6> or make your constraints deferred and populate the db in a transaction
<4> yea i guess so - thanks =)
<7> tenfour: what exactly is the data?
<7> theres ways to automatically do it but diff ways for diff circumstances
<8> what's the question?
<7> [12:46:54] <4> i'm looking for a different way to populate a database with a bunch of test data than to write a script with a bunch of inserts
<7> [12:47:35] <4> i can't just import a csv or xls because i want primary keys to be hooked up and stuff (so right now i'm doing set @blahID = scope_identity() )
<7> [12:50:13] <5> you can import from csv or whatever as long as you (a) ensure the keys match and (b) import them in the right order
<4> there are about 12 tables of data, FK's all over. right now i have a create schema script, and a populate data script (for entering initial testing data)
<7> tenfour: i dont know exactly what kind of testing you are doing but if turning off autoincrement is an option thats something i would look into
<9> isnt that prtty much what dts is for?
<4> but our test data changes a lot so i was trying to find a way to have some spreadsheet or XML or something which can be imported
<4> i have the feeling i'll just enable identity insert & DTS an excel spreadsheet
<4> i'm working on it later today
<7> tenfour: CoJoNEsXx has a point but i cant remember how dts handles autoincrements
<7> btw... why the hell did sql server 2005 have to go and rename DTS to SSIS?
<8> because it's DTS on drugs afaik
<9> MS likes to rewrite things that work every few years
<10> b/c it is no longer DTS
<10> its completely different
<9> but leave things that are horribly broken still broken in the name of backward compatability :)
<10> SSIS is actually pretty damned slick
<7> CoJoNEsXx: heh
<10> comparable to informatica and data stage from ibm
<9> ive actually read good things about it
<7> ShrikeX: unfortunately i have not had a chance to even thouch it :( but cant they just call it DTS?
<7> i mean.. the TSQL changed.. but they didnt rename it to something else
<11> hey can someone help me for a min?
<10> SicLuDe its not DTS anymore
<10> its a completely new product
<10> spoof3r no
<9> your clock has started then spoof3r
<7> spoof3r: sorry we dont have mindreading powers
<10> go somewhere else for help
<7> go to #mindreaders
<10> like #teen***
<11> :D
<7> lol we are all ***holes :)
<10> good
<11> lol
<10> before you can get help here your self esteem must be lowered to nothing
<7> spoof3r: ur an idiot.. how do u expect us to help if you dont ask a question?
<7> lets see how long he goes without asking a question
<4> he already asked 1 question
<11> ok then here goes. I am making a site and i need to make a database that has the names of different people, and then i can do a "site search" on a name, and then get all the info for that name
<7> spoof3r: marvelous idea
<7> very innovative i must say
<9> im sure there cant be anything similar
<11> :P just need some help
<9> even in a tutorial
<9> @ learnsql
<12> learnsql = http://sqlzoo.net/ http://sqlcourse.com http://sqlcourse2.com ,this is my way of telling you that you make no sense
<7> whats a tutorial?
<7> d2d_w0rk: you there dude?
<13> a tutorial is where you send me $200 and i pretend i'm a phone *** operator
<9> thats hot
<7> o no u dont... im not falling for that one again
<7> i learned my lesson after 2 times
<13> :)
<11> heh
<7> u know.. i truly wanted to help spoof3r if only he had asked a question
<11> ..i did
<11> ;p
<7> what was your question?
<7> aside from "can anyone help me?"
<11> i said i needed help setting up a database that would hold different people's names
<7> thats a statement
<7> not a question
<11> oh ok
<11> can someoen help me develop it?
<11> or walk me through the basic steps on how to do this
<7> ask specific questions stupid
<11> (better?)
<13> holding your hand $150/hr
<7> better but not good enough
<13> spoon feeding $150/hr
<13> help is free though
<13> spoof3r basically if we have to do your work you are going to pay us
<11> heh ok more detail...
<13> you do your work and maybe need some help, we're happy to oblige
<7> a good question would be something like this: what data type would be good for a username and p***word?
<7> you would get rediculed for a question like htat but you will get an answer
<11> haha ok
<11> sry :P
<7> for future reference.. that philosopy isnt unique to this channel
<7> any tech chan will basically have the same attitude
<11> ok so let me make sure i haev this right, i have never used SQL so just checking. I created a table, gave it a name
<7> read a few tutorials then
<11> i have options like "Column, Alias, Table, output, Sort Type, Sort Order, Filter
<13> spoof3r what rdbms are you using
<7> and this isnt just to get you away ... it will help you a great deal if you had some background knowledge so you know what actual questions to ask
<7> whats an rdbms?
<13> it's right next to your CVV2 on your credit card
<13> please read me the digits
<11> lool
<7> whats a CVV2?
<7> :)
<13> eh
<13> just start reading every number in order on the shiney plastic card
<13> i'll sort it out for ya because i'm your friend
<7> heh
<11> :P
<7> heh u use my credit card they will come after you... been hiding from them for years ;)
<7> they will think you are me
<11> ok well
<11> http://sqlcourse.com/select.html
<7> great you learned how to paste
<11> looks like i wnat to make something like the table in there about half way down
<13> so go for it
<7> :)
<13> are we motivational speakers now?
<7> dude seriously.. go read some tutorials
<13> usually people get paid for that
<11> but all my options for the table say Column, ALias, Table
<11> -.- fine
<7> ya phil jackson gets like 10000 an hour
<7> spoof3r: Darken| asked you what rdbms u are using.. and you hvae yet to answer him
Return to
#sql
or
Go to some related
logs:
usb 0b05 1726
manipulate wordlist ubuntu
#flash
#politics
onEnterframe stop execution
#beginner
#linuxhelp
#computers
#microsoft
vbavarforinit
|
|