Tamamlanmış

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]

Beceriler: Powershell, Microsoft SQL Server, SQL, C# Programlama, Yazılım Mimarisi

Daha fazlasını gör: 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

İşveren Hakkında:
( 1 değerlendirme ) FRISCO, United States

Proje NO: #21891428

Seçilen:

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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 150%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(2 Değerlendirme)
3.0

Bu iş için 7 freelancer ortalamada $180 teklif veriyor

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 in 3 gün içinde
(102 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(26 Değerlendirme)
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 Daha Fazla

$200 USD in 2 gün içinde
(16 Değerlendirme)
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 Daha Fazla

$277 USD in 2 gün içinde
(3 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
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 Daha Fazla

$200 USD in 2 gün içinde
(0 Değerlendirme)
0.0