Đã hoàn thành

Need power shell script for database and SQL instance inventory.

Need 2 powershell script:

Purpose: Create an inventory of SQL databases and SQL instances ( instance and Windows machine) and store in two different table

1) I will run the [login to view URL] script from my machine.

2) It will read a textfile from C:\Jamil\[login to view URL] where one server name per row (Sample file attached)

3) It will insert the values in SQL table called [dbo].[Databases] similar to SQLDatabaseInfo tab in the attached EXCEL

4) I will run the second script [login to view URL] it will read the same file as before c:\Jamil\[login to view URL]

and insert the values in [login to view URL] table similar to SQLServerInfo tab in the attached EXCEL

5) In one of my SQL instance, I will create DBA database which will have 2 tables [login to view URL]

and [login to view URL]

For your reference here is the template for Databases table

-- Create table [login to view URL]

CREATE TABLE [dbo].[Databases](

[DatabaseID] [int] IDENTITY(1,1) NOT NULL,

[InstanceName] [varchar](50) NOT NULL,

[DatabaseName] [varchar](200) NOT NULL,

[CreateDate] [varchar](10) NOT NULL,

[Status] [varchar](10) NOT NULL,

[UPdatebility] [varchar](20) NOT NULL,

[db_size] varchar [varchar](20) NOT NULL,

[DatafileSize] varchar [varchar](20) NOT NULL,

[LogFileSize] varchar [varchar](20) NOT NULL,

[Owner] [varchar](100) NOT NULL,

[RecoveryModel] [varchar](10) NOT NULL,

[LoadDate] [date] NOT NULL,

CONSTRAINT [PK_Databases__DatabaseID] PRIMARY KEY CLUSTERED

(

[DatabaseID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

** You need to write the script in such a way that once I execute the script it will insert the values in [login to view URL]

and [login to view URL] table. SQL instance name where DBA database resides can be given hard coded.

-- Create table [login to view URL]

CREATE TABLE [dbo].[Databases](

[DatabaseID] [int] IDENTITY(1,1) NOT NULL,

[InstanceName] [varchar](50) NOT NULL,

[DatabaseName] [varchar](200) NOT NULL,

[CreateDate] [varchar](10) NOT NULL,

[Status] [varchar](10) NOT NULL,

[UPdatebility] [varchar](20) NOT NULL,

[db_size] varchar [varchar](20) NOT NULL,

[DatafileSize] varchar [varchar](20) NOT NULL,

[LogFileSize] varchar [varchar](20) NOT NULL,

[Owner] [varchar](100) NOT NULL,

[RecoveryModel] [varchar](10) NOT NULL,

[LoadDate] [date] NOT NULL,

CONSTRAINT [PK_Databases__DatabaseID] PRIMARY KEY CLUSTERED

(

[DatabaseID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

Kĩ năng: Powershell, Microsoft SQL Server, SQL, Lập trình C#, Kiến trúc phần mềm

Xem nhiều hơn: sql script database changes, oscommerce database sql script, script database bcp sql 2008, shell script database project linux, accounts database sql script, script copy database sql server 2000, asterisk script connect sql database, database sql script, asp script export sql database, script size sql database, power shell script active directory create users excel, create script backup database sql server, backup database sql server script, create database php script install sql file, database sql server vb script, linux inventory shell script, online airlines reservation system project java script database sql then create, script database sql convert wordpress, execute unix shell script database trigger

Về Bên Thuê:
( 1 Nhận xét ) FRISCO, United States

ID dự án: #21891428

Được trao cho:

kennethgarza

hello. I hope you're doing well. im an expert in sql and powershell and have written many scripts similar to this one. I am ready to get started right away, so send me a message when you're ready so we can chat about Thêm

$150 USD trong 2 ngày
(2 Đánh Giá)
3.0

7 freelancer đang chào giá trung bình $180 cho công việc này

polarjin2017

Hello? How are you? I am excited to work with you on this project. I have good skills in those. So I think I can help you if you want. So i hope to discuss your project vis chat deeply. Thanks. Best regards.

$155 USD trong 3 ngày
(102 Nhận xét)
6.8
ITPyramid85

I CAN COMPLETE YOUR PROJECT EASILY Hello, I am software developer with enough experiences on C# for 13 years. I can work by full time for your project and trying to satisfy the requirements. I am designing the project Thêm

$140 USD trong 7 ngày
(26 Nhận xét)
6.9
LiaoFang

Hi, Good day! I'm a high-skilled PS developer and have lots of experiences in building powershell scripts. I've read you project description carefully and very interested. Let's discuss further more and get started. P Thêm

$200 USD trong 2 ngày
(16 Nhận xét)
5.2
dat2na

Greetings, I'm professional database and BI expert with 12+ years experience. Currently I'm working as Senior DW, BI & DB developer in one of the leader financial corporation. As you can see in my profile page, I have Thêm

$277 USD trong 2 ngày
(3 Nhận xét)
4.2
Devrits

Hi Hiring manager I have read your all given information in description and i am ready to do various type of work for you and available 24*7*365 for you. 1* I can do Data RESEARCH from any platform for certain subjects Thêm

$140 USD trong 1 ngày
(3 Nhận xét)
1.9
Dito24

How are you? I have 8+ years of experience in C#/C++/JAVA programming. I have read your project description fully. I can understand and finish it wonderfully . I guarantee high project development and quality as a Thêm

$200 USD trong 2 ngày
(0 Nhận xét)
0.0