Prev: What does "Invalid pseudocolumn "$v"." mean?
Next: better to filter on join or where clause
From: Sylvain Lafontaine on 7 Apr 2010 12:31
Yes but don't forget to look at what you might already have on your actual
web site.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"Mario" <mzupan(a)vup.hr> wrote in message
news:hphtcr$92n$1(a)news2.carnet.hr...
> And this is even better tutorial.
> http://weblogs.asp.net/scottgu/archive/2007/01/11/tip-trick-how-to-upload-a-sql-file-to-a-hoster-and-execute-it-to-deploy-a-sql-database.aspx
>
> "Mario" <mzupan(a)vup.hr> wrote in message
> news:hphp17$ntq$1(a)news2.carnet.hr...
>>
>> I think I found it:
>> http://www.brighthub.com/internet/web-development/articles/9410.aspx
>>
>> Thank you on your great help.
>>
>> "Mario" <mzupan(a)vup.hr> wrote in message
>> news:hphof0$lr4$1(a)news2.carnet.hr...
>>>
>>> "Sylvain Lafontaine" <sylvainlafontaine2009(a)yahoo.ca> wrote in message
>>> news:%23715rob1KHA.4724(a)TK2MSFTNGP02.phx.gbl...
>>>> For running the scripts, you will have to have something on your web
>>>> site to run them against the web server. An easy way is simply to
>>>> build an ASP.NET page with all the scripts inside it and some command
>>>> to run them. The ASP.NET page could also open a file with the script in
>>>> them, read it and execute the scripts.
>>>>
>>> Can I find the example of such aspx file ? What to google ?
>>>> Some providers will offer you a web interface from which you can run
>>>> your script.
>>> I was looking on my DotNetPanel, but didn't find anything to run sql
>>> scripts ? DotNetPanel can only create database without tables creating
>>> capabilities.
>>>
>>>> Having an IP for SQL-Server accessible from your personal computer (the
>>>> internet) is very useful and will greatly simplify the process of
>>>> creating/updating your databases. However, most hosts won't give you
>>>> this opportunity for security reasons and for those who do, the costs
>>>> of the hosting is usually much more higher because they have a lot more
>>>> to do to keep their systems secure.
>>>>
>>>
>>> You are right. I ask my administrator and he said that it is not a usual
>>> procedure to give me an IP for security reason, just like you said.
>>>
>>>
>>>> Sylvain Lafontaine, ing.
>>>> MVP - Windows Live Platform
>>>> Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
>>>> Independent consultant and remote programming for Access and SQL-Server
>>>> (French)
>>>>
>>>>
>>>> "Mario" <pascal(a)po.t-com.hr> wrote in message
>>>> news:hpfttn$r2i$1(a)ss408.t-com.hr...
>>>>>
>>>>> "Mario" <pascal(a)po.t-com.hr> wrote in message
>>>>> news:hpam81$460$1(a)ss408.t-com.hr...
>>>>>> On 04.04.2010. 20:04, Sylvain Lafontaine wrote:
>>>>>>> The real problem is when you want to make changes to an existing
>>>>>>> database.
>>>>>>> With SSMS, you can generate a differential script when you make
>>>>>>> change to a
>>>>>>> table but you need to collect all of them along; which is not an
>>>>>>> easy work.
>>>>>>> Personally, I prefer to use a sql-server comparaison tool that can
>>>>>>> compare
>>>>>>> two different versions of a database and generate all the required
>>>>>>> scripts
>>>>>>> necessary to bring one identical to the other. Myself, I use the
>>>>>>> one
>>>>>>> provided by Red-Gate but you can find many others on the internet,
>>>>>>> some of
>>>>>>> them free.
>>>>>>>
>>>>>>> Completely free tools:
>>>>>>>
>>>>>>> http://www.codeplex.com/OpenDBiff
>>>>>>> http://www.codeplex.com/DbDiff
>>>>>>>
>>>>>>> Tools that are free if you are using SQL-Server Express:
>>>>>>>
>>>>>>> http://www.teratrax.com/tdc/
>>>>>>> http://www.xsqlsoftware.com/LiteEdition.aspx
>>>>>>>
>>>>>>> Other free tools that can be useful:
>>>>>>>
>>>>>>> http://www.sqlservercentral.com/articles/Tools/64908/
>>>>>>> http://www.sqlservercentral.com/Forums/Topic356421-283-1.aspx
>>>>>>> http://www.sqlservercentral.com/articles/Miscellaneous/2959/
>>>>>>>
>>>>>>> http://weblogs.sqlteam.com/mladenp/archive/2007/11/20/Free-SQL-Server-tools-that-might-make-your-life-a.aspx
>>>>>>>
>>>>>>> Some of those free tools to work with SSMS (not necessarily to
>>>>>>> compare two
>>>>>>> databases) won't work with the Expres edition (SSMS-E). Personally,
>>>>>>> I think
>>>>>>> that it's worth it to buy the Developer Edition of SQL-Server
>>>>>>> (around 50$US)
>>>>>>> to get access to the full version of SSMS instead of SSMS-E. If
>>>>>>> you're
>>>>>>> serious about working with SQL-Server, 50$ is not a big deal.
>>>>>>>
>>>>>>
>>>>>> Thank you on your great help. I will pass all that links. One more
>>>>>> question is: How I will run generated script and will I get a
>>>>>> permission from admistrator?
>>>>>
>>>>> For scripts running, I also need an IP of SQL server, do I ?
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


First  |  Prev  | 
Pages: 1 2 3
Prev: What does "Invalid pseudocolumn "$v"." mean?
Next: better to filter on join or where clause