Database Discussion Boards

Shrimpersfan21-Apr-09 23:54

21-Apr-09 23:54

Thank you for all of your replies, it seems that I have lost all of the data and as you said I have learnt the hard way that we should keep on top of ALL our backups. Thankfully it shouldn't take too long to recreate the tasks, just means by busy couple of months just got a whole lot busier.

Thanks again

David

Running the upgrade step from version 539 to version 551

Vimalsoft(Pty) Ltd21-Apr-09 1:03

Vimalsoft(Pty) Ltd

21-Apr-09 1:03

Good Day All

I have Used Red Gate to Synchronise the SQl Database in 200 and the other in 2005. and it went well, now i have a SP that is Running in my application that restores the Database like this

RESTORE DATABASE LOV FROM DISK = 'C:\DATABASES\MasterDatabase'    
WITH   MOVE 'oBooking_Data' TO 'C:\DATABASES\LOV.mdf',   
MOVE 'oBooking_Log' TO 'C:\DATABASES\LOV_log.ldf',
REPLACE,RECOVERY;[/

Now My Application Halt and gives me the Following Error, i have tried to run it manually from the T-SQL and i got this

Processed 368 pages for database 'LOV', file 'oBooking_Data' on file 1.
Processed 1 pages for database 'LOV', file 'oBooking_Log' on file 1.
Converting database 'LOV' from version 539 to the current version 611.
Database 'LOV' running the upgrade step from version 539 to version 551.
Database 'LOV' running the upgrade step from version 551 to version 552.
Database 'LOV' running the upgrade step from version 552 to version 553.
Database 'LOV' running the upgrade step from version 553 to version 554.
Database 'LOV' running the upgrade step from version 554 to version 589.
Database 'LOV' running the upgrade step from version 589 to version 590.
Database 'LOV' running the upgrade step from version 590 to version 593.
Database 'LOV' running the upgrade step from version 593 to version 597.
Database 'LOV' running the upgrade step from version 597 to version 604.
Database 'LOV' running the upgrade step from version 604 to version 605.
Database 'LOV' running the upgrade step from version 605 to version 606.
Database 'LOV' running the upgrade step from version 606 to version 607.
Database 'LOV' running the upgrade step from version 607 to version 608.
Database 'LOV' running the upgrade step from version 608 to version 609.
Database 'LOV' running the upgrade step from version 609 to version 610.
Database 'LOV' running the upgrade step from version 610 to version 611.
RESTORE DATABASE successfully processed 369 pages in 0.204 seconds (14.782 MB/sec).

Thank you

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Table insertion?

Karthick_gc20-Apr-09 23:09

Karthick_gc

20-Apr-09 23:09

Hi to all,
I have a mail table with the fields like id,to,receiver,subject,description,date etc..

when i fill the to field with multiple receipient seperated by comma, i want to store in the table for all members.

How it is possible?

Re: Table insertion?

Mycroft Holmes20-Apr-09 23:14

Mycroft Holmes

20-Apr-09 23:14

So split the recipeints by comma and repeat the insert for each one.

Never underestimate the power of human stupidity
RAH

Re: Table insertion?

Karthick_gc20-Apr-09 23:17

Karthick_gc

20-Apr-09 23:17

Yes. Can u tell how to split and insert for each receipient?

Re: Table insertion?

Mycroft Holmes20-Apr-09 23:27

Mycroft Holmes

20-Apr-09 23:27

I just did, split the recipients using text.split
Insert each record using your current insert method, changing the recipeint each time.

Never underestimate the power of human stupidity
RAH

Re: Table insertion?

Karthick_gc20-Apr-09 23:44

Karthick_gc

20-Apr-09 23:44

I cant get.Can u describe briefly?

Re: Table insertion?

Mycroft Holmes21-Apr-09 0:34

Mycroft Holmes

21-Apr-09 0:34

What are you doing over here - go back to the ASP forum where they may have more patience with fools - you obviously have no idea what you are doing.

Never underestimate the power of human stupidity
RAH

Data Modeling

Muhammad Nauman Yousuf20-Apr-09 19:37

Muhammad Nauman Yousuf

20-Apr-09 19:37

Dear All,

I am looking for the best data modeling tool,
Objective: I have an SQL database up and running, i want to have the best tool in order to architecture and document my DB.

Regards,
Muhammad Nauman

"Mess with the Best, Die like the rest"

Re: Data Modeling

riced20-Apr-09 22:14

riced

20-Apr-09 22:14

Try googling for "database reverse engineering" - 400K+ hits. Smile | :)

Regards
David R

Re: Data Modeling

dingoishere23-Feb-11 22:36

dingoishere

23-Feb-11 22:36

Try D-Softs database compare tool

How to read values from excel formula fields?

Nagaraj Muthuchamy20-Apr-09 7:53

Nagaraj Muthuchamy

20-Apr-09 7:53

Hi, I have been trying this for two days.

Is it possible to load the calculated Excel fields in to dataset.

I am using Ado.Net and Oledb to read excel.

Thanks,
Nagaraj

Umbraco Developer

Re: How to read values from excel formula fields?

N a v a n e e t h20-Apr-09 17:06

N a v a n e e t h

20-Apr-09 17:06

What is calculated excel fields?

Navaneeth

How to use google | Ask smart questions

Re: How to read values from excel formula fields?

Nagaraj Muthuchamy20-Apr-09 21:49

Nagaraj Muthuchamy

20-Apr-09 21:49

Excel cell which is having Excel Formula instead of value.

Thanks,
Nagaraj

Umbraco Developer

MS Sql Database synchronization

Paul Brower20-Apr-09 5:55

Paul Brower

20-Apr-09 5:55

We've used Intellisync in the past for synchronizing databases ... they've basically gone out of busines, and I'm interested in knowing what software others use to synchronize ms sql databases.

The software has to be capable of implementing rules for synchronization, so I can sync select data / tables.

Thanks!

Paul Brower

Re: MS Sql Database synchronization

Giorgi Dalakishvili20-Apr-09 6:10

Giorgi Dalakishvili

20-Apr-09 6:10

What about writing your own using Sync Framework?

Giorgi Dalakishvili

#region signature
My Articles

Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^]

My blog
#endregion

Bulk Insert

Hemalatha.A.M.20-Apr-09 5:40

Hemalatha.A.M.

20-Apr-09 5:40

Hi i try to insert 195 countries at a time in sql. For that i have used BULK insert query. My Query is
BULK INSERT hrmsuser.country FROM 'C:\data.txt'WITH (
DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )

MYPROBLEM:
Cannot bulk load. The file "C:\data.txt" does not exist.
Pls Anyone Help Me........

Re: Bulk Insert

Eddy Vluggen20-Apr-09 7:09

Eddy Vluggen

20-Apr-09 7:09

Hemalatha.A.M. wrote:
The file "C:\data.txt" does not exist.

Those 195 countries are listed in a file? I'll bet that the file isn't called "C:\Data.txt"..

I are troll Smile | :)

Re: Bulk Insert

Luc Pattyn20-Apr-09 7:26

Luc Pattyn

20-Apr-09 7:26

what is it called then?

Laugh | :laugh:

Luc Pattyn [Forum Guidelines] [My Articles]

Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in

Re: Bulk Insert

Eddy Vluggen20-Apr-09 9:25

Eddy Vluggen

20-Apr-09 9:25

I dunno Sensei, it didn't say in the error-message Sniff | :^)

Although.. it might be listed in the file "C:\pagefile.sys". Yeah, that's the one he should parse! Cool | :cool:

I are troll Smile | :)

Re: Bulk Insert

Luc Pattyn20-Apr-09 9:29

Luc Pattyn

20-Apr-09 9:29

pagefile is locked Cry | :((

Luc Pattyn [Forum Guidelines] [My Articles]

Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in

Re: Bulk Insert

Eddy Vluggen20-Apr-09 11:12

Eddy Vluggen

20-Apr-09 11:12

Luc Pattyn wrote:
pagefile is locked

My bad, the file is indeed locked whilst Windows' runs. That's quite easy to patch though, may I kindly suggest these steps;

* Put your swapfile on an USB-stick
Right-click "My Computer", choose "Properties", Tabpage "Advanced", button "Settings" of the groupbox "Performance", Tabpage "Advanced", button "Change" of the groupbox "Virtual Memory".

* Load the textfile into your favorite webbrowser. You can either view it locally, or find a good host for this file, preferably with FTP-access and high uptime.

* Minimize the browser, and load a 4 Gb movie on Kiwi's (the bird, not the fruit) into MovieMaker. This might cause the contents of the browser to be swapped to virtual memory. I say might, as one never can be sure whether God is or isn't addicted to playing dice.

* Yank out the USB-stick as quickly as you can, so that only a minimum amount of bits will spill out of the USB-port. You now have a crashed Windows-system and a pagefile on USB-disk.

* Reinstall Windows, and when done, run chkdsk.exe on your USB-stick. Pray to Codd, while sacrificing a HP-calculator during the first Googledance.

There you have it; a "pagefile.sys", that may or may not contain a complete or partial list in a non-readable format, ready to be peek'd, poke'd and goes very well with mayonaise Smile | :)

I are troll Smile | :)

Re: Bulk Insert [modified]

Luc Pattyn20-Apr-09 11:28

Luc Pattyn

20-Apr-09 11:28

So now I have to order:
- a PC with USB (making sure I have a Win install disk)
- a USB stick (easily yankable)
- a Kiwi movie (any recommendation?)
- a set of napkins to clean up spilled bits
- an HP calculator
[ADDED] No mayonaise; still have some [/ADDED]

I think I'd rather spend half an hour looking up countries in Wikipedia and recreating the list myself. Actually I could write a program to do just that...

Confused | :confused:

Luc Pattyn [Forum Guidelines] [My Articles]

Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in

modified on Monday, April 20, 2009 5:38 PM

Re: Bulk Insert

Eddy Vluggen20-Apr-09 20:36

Eddy Vluggen

20-Apr-09 20:36

It does sound like a good idea to create an application to automate the task of reading the Wikipedia. I'm looking forward to your article $Shucks | :-\$

I are troll Smile | :)

Re: Bulk Insert

Mycroft Holmes20-Apr-09 23:19

Mycroft Holmes

20-Apr-09 23:19

Highly likely your file is on your local c drive and you are executing the bulkcopy on the server so it is looking at the servers c drive!

Never underestimate the power of human stupidity
RAH

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.