Database

Re: How to protect sqlserver database from unauthorized access

30-Jul-09 8:29

shine_paravur wrote:
Can you help me to protect sql server 2005 database from unauthorized access.I am using C#.net2005.

1. Use Windows Authentication mode, insted of SQL Server Authentication Mode ( As Windows Authentication Mode used ActiveDirecotry to Authenticate user)
2. As you are asking about C# too,
Please Encrypt your connection String Big Grin | :-D

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Robin_Roy30-Jul-09 16:45

Re: Checklist for migrating Sql Server 2000 based websites to 2005 based websites

30-Jul-09 16:45

There are few options here for you:
Using Windows authentication to access the database.
Using SQL authentication to access the database.

For Windows Authentication, you need to use Active Directory User to map to your database.
For SQL Authentication, you need to create a SQL User and map the appropriate Roles and map with your database.

In your C# application, encrypt your connection string and use the same.

Many a times in shared deployment environment, they allow on SQL Authentication only, in such a case you will have to use SQL Authentication.

[Message Deleted]

Balaji_rcs30-Jul-09 0:09

Balaji_rcs

30-Jul-09 0:09

[Message Deleted]

Ashfield30-Jul-09 1:58

Ashfield

30-Jul-09 1:58

How would anyone that doesn't know anything about your website or database be able to tell you? Surely its a matter of common sense.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: Checklist for migrating Sql Server 2000 based websites to 2005 based websites

Abhijit Jana30-Jul-09 8:32

Re: Checklist for migrating Sql Server 2000 based websites to 2005 based websites

30-Jul-09 8:32

Balaji_rcs wrote:
The Checklist items should cover both front end and back end. What are the steps to follow to test the back end environment and also the website

I guess you are using some tool or SQL Server itself to migrate the DB. So I am sure there should not be any messup.

If you are asking about checklist to be cover for both Front End and BackEnd,
I will Say, you need to run ALL THE TEST CASES to check the functionlaity is working fine or not Wink | ;)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Robin_Roy30-Jul-09 16:50

Need Checklist for migrating Sql Server 2000 based websites to 2005 based websites

30-Jul-09 16:50

If you are migrating the database from SQL Server 2000 to 2005, there should ot be any issue as such as SQL Server 2005 is backward compatible and all the statements, functions and other database objects and syntax of SQL Server 2000 works fine in SQL Server 2005.
In case of conflict, during migration it will show the alerts.

However for double checking, you can run through the test cases that are meant for sections, that have database transactions.

Balaji_rcs30-Jul-09 0:06

Balaji_rcs

30-Jul-09 0:06

Hi,

Recently, my team migrated the websites from sql server 2000 to sql server 2005. My leader asked to prepare the checklist to do testing the sites in both front end and back end. Can anyone please share the checklist items to do the testing.

The Checklist items should cover both front end and back end. What are the steps to follow to test the back end environment and also the website.

Re: Need Checklist for migrating Sql Server 2000 based websites to 2005 based websites

Jerry Hammond30-Jul-09 3:09

Jerry Hammond

30-Jul-09 3:09

Is this a specific question or simply a request for free consultancy for your company?

Anyways, if it is the former then please post your schema and database diagrams so that we may have something to start from for our answer.

If it is the latter, then please send the 25k US retainer to Code Project for answers... Poke tongue | ;-P

"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering

Re: Need Checklist for migrating Sql Server 2000 based websites to 2005 based websites

Robin_Roy30-Jul-09 16:52

Is it possible to design Custom Constraints ???

30-Jul-09 16:52

Hey, I guess you repeated your question.

www.Developerof.NET29-Jul-09 22:15

www.Developerof.NET

29-Jul-09 22:15

Hi all,

I need to know whether SQL provides custom constraints??? i.e if i want to enforce a constraint on a Parent table given that its key is been referenced as a foriegn key in a child table, that it should have atleast one child???

Is it possible?????

When you fail to plan, you are planning to fail.

Re: Is it possible to design Custom Constraints ???

Robin_Roy30-Jul-09 16:54

Join two tables of different servers in SSIS

30-Jul-09 16:54

You can wrte triggers for the same. However it is not a good approach.
Better check in your stored procedure with the condition...

CodalcoholicNBrainy29-Jul-09 7:12

CodalcoholicNBrainy

29-Jul-09 7:12

Hi,

I am new to SSIS. I have two different servers, one is AS400 and other in SQL server. There is one table ABC on AS400 and two table ABC and XYZ in SQL server. I need to take the join of the tables ABC (of AS400) and XYZ of SQL server and need to push the matching records into ABC table of SQL server.

Please advise me how can I achieve this in SSIS.

Thanks in Advance.

CodeManiac
xxxxxxxxxx
xxxxxxxxxx

Abhijit Jana29-Jul-09 7:19

29-Jul-09 7:19

This may help you Big Grin | :-D

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

CodalcoholicNBrainy29-Jul-09 7:25

CodalcoholicNBrainy

29-Jul-09 7:25

Hi Abhijit,
Thanks for quick reply. But on clicking the link "This may help you", it redirects me to some where else and I do not have any registration there.
It would be great if you can post the solution here.
Thanks Big Grin | :-D

CodeManiac
xxxxxxxxxx
xxxxxxxxxx

Abhijit Jana31-Jul-09 9:45

31-Jul-09 9:45

I really surprised to see the same thing happening with me. D'Oh! | :doh:

It was fine, when I was post the answer. D'Oh! | :doh:

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Syed Mehroz Alam1-Aug-09 2:02

Syed Mehroz Alam

1-Aug-09 2:02

Hi Abhijit/CodeManiac,

Expert exchange displays the answers at the bottom when your referrer is Google. Try searching for the question title "Linking, Connecting MS SQL 2000 to AS400 Database" using Google, go to the first result, and scroll down to the bottom of page to view the replies.

Hope that helps.

Regards,

Syed Mehroz Alam
My Blog | My Articles

Computers are incredibly fast, accurate, and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination. - Albert Einstein

Robin_Roy29-Jul-09 17:53

synchronization of two databases

29-Jul-09 17:53

One option could be, create multiple Data Source (one for AS400 and another for SQL Server) in your DataFlow task and then use Union All Data Flow transformation Item and set the output to one Data Destination that is your SQL Server.

Robert Vrinceanu28-Jul-09 21:35

Robert Vrinceanu

28-Jul-09 21:35

Hi,
I have two identical databases whitch are different only by name (DB1 and DB2)
Eatch database is on one computer (PC1 and PC2) into a network.
Database DB1 contains table Tab1.
Database DB2 contains table Tab2.
The two tables Tab1 and Tab2 are identical as structure an receive the same data from an external aplication.
There are moments when the network is interrupted, from different causes and the two tables no longer contains the same data.
To synchronize the tables I have to copy only the rows which are lost from Tab1 in Tab2.
By a stored procedure i have to know which are the numbers of rows lost from Tab2 to fill in with rows from Tab1
I actually have to copy a number of lines from Tab1 in Tab2 with the condition to know which are the rows lost from Tab2.
Someone knows how can I do that? Thanks.

SeMartens28-Jul-09 23:43

SeMartens

28-Jul-09 23:43

Hi
Do you rows have an unique identifier? If yes you could use something like this:

insert into tab2 select * from tab1 where not exists (select table2.id from tab2 as table2 where table2.id = tab1.id)

This will only work for added rows. Changing existing rows and synchronizing deleted rows will not work with this.

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Blue_Boy29-Jul-09 0:35

Blue_Boy

29-Jul-09 0:35

Use this:

Case 1

Insert into DB1.dbo.Table1 <br />
select * DB2.dbo.Table2 from where DB2.dbo.Table2.ID not in (select DB1.dbo.Table1.ID from DB1.dbo.Table1 )

Case 2:

Insert into DB2.dbo.Table2 <br />
select * DB1.dbo.Table1 from where DB1.dbo.Table1.ID not in (select DB2.dbo.Table2.ID from DB2.dbo.Table2)

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Robert Vrinceanu29-Jul-09 3:51

Robert Vrinceanu

29-Jul-09 3:51

Thank you all.
The problem is that databases DB1 and DB2 are on different computers.

Eddy Vluggen29-Jul-09 6:15

Eddy Vluggen

29-Jul-09 6:15

What brand are DB1 and DB2? If it's SQL Server, you could add a linked server[^] Smile | :)

http://www.sqlaccessories.com/SQL_Data_Examiner/[^]

David Skelly29-Jul-09 5:21

David Skelly

29-Jul-09 5:21

Robin_Roy29-Jul-09 17:55